DSXchange

Hi Folks, I am trying to execute a SQL via a PL/SQL block using the Oracle Connector stage. Example as follows :- declare sql_stmt varchar2(4000); begin sql_stmt := 'SELECT SECTOR_ID FROM SECTOR_DIM'; execute immediate sql_stmt; end; I have defined the SECTOR_ID column in the Oracle Connector stage ...

ray.wurlod wrote:Many moons ago I built such a dynamic rules engine using server jobs and server routines, using a feature of the server engine called "indirect call" where the name of the routine does not need to be ...

Premium content

Thanks for your reply asorrell. Yes, this is the only approach which i had in mind too but there are quite a number of other columns which have such rules which would make the job design a mess. From what i have read so far there is no feasible way of having this implemented in DataStage natively in...

Thanks for your reply chulett. Will have a look at it! Skimming through though it would seem that this stage is ideal more on the data validation front rather than transformation/lookups. To bring more clarity to my question. Assume we have column A and the following are the rules and their transfor...

Hi Folks, I know this has been asked before but I had not seen a proper response and uncertain as to whether my question actually falls in line with the questions posed by the rest of the members. Question :- (a) We have a table which has 10 columns (b) We have to perform transformations/lookups on ...

Thanks Chulett. Did some further troubleshooting and it seems that it was related to something wrong with the DSX itself. Unfortunately I cannot pinpoint what exactly was wrong with the DSX to comment on this further either :( I took a fresh export of a couple of other jobs and they worked fine when...

Hi Chulett, Thanks alot for the new thread! I am running this on DS 11.3 on UNIX. As for the syntax, the following is what we are using :- DSXImportService.sh -ISAuthFile $ds_ISFile -DSProject $project_Name -DSXFile $dsx_Path -OverwriteReadOnly -Verbose I tried with -Overwrite and still faced the sa...

Hi Folks, I am facing the exact same issue as the author of this post. The import fails when the job exists in the project. After deletion of those jobs the import works fine. The command i uses has the -Overwrite flag too. I tried with -OverwriteReadOnly and it still fails the import. Any idea? Reg...

Mark - No worries Mark. That JR would have been really helpful as I do not have direct access to IBM support to inquire about the patch :( Thanks for your reply though! Atleast you confirmed the existence of a patch release by IBM for this issue. chulett - I tried the following. Please correct me if...

Any luck with the PMR Mark? Is there a JR created for this?

Hisham

Hi Ray, Apologies for the delay in replying. As of your question, yes. I have created a separate local administrative account for all installations. After multiple retries I am now facing the falling issue which is similar to the one thrown earlier :- com.ibm.is.install.exception.ActionException: CD...

Hi Guys, I have been trying to install Information Server 8.5 64 bit (all tier) onto a Windows Server 2008 R2. The machine has adequate hard disk space and memory. The OS is 64 bit and the installation we are using is also 64 bit. There is no fancy configurations whatsoever and is a mere straightfor...