Search found 12 matches
- Thu Dec 21, 2017 12:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read data via Oracle Connector using PL/SQL
- Replies: 0
- Views: 2582
Read data via Oracle Connector using PL/SQL
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 ...
- Thu Jul 27, 2017 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic transformation/lookup at a columnar level (Rules Eg)
- Replies: 6
- Views: 4210
- Tue Jul 25, 2017 1:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic transformation/lookup at a columnar level (Rules Eg)
- Replies: 6
- Views: 4210
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...
- Mon Jul 24, 2017 2:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic transformation/lookup at a columnar level (Rules Eg)
- Replies: 6
- Views: 4210
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...
- Mon Jul 24, 2017 10:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic transformation/lookup at a columnar level (Rules Eg)
- Replies: 6
- Views: 4210
Dynamic transformation/lookup at a columnar level (Rules Eg)
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 ...
- Thu Jul 13, 2017 9:06 am
- Forum: General
- Topic: dsx import error
- Replies: 4
- Views: 2728
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...
- Wed Jul 12, 2017 2:05 pm
- Forum: General
- Topic: dsx import error
- Replies: 4
- Views: 2728
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...
- Wed Jul 12, 2017 11:00 am
- Forum: General
- Topic: dsx import error
- Replies: 4
- Views: 2728
dsx import error
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...
- Thu Jan 12, 2017 8:59 am
- Forum: General
- Topic: Oracle Connector in multiple clients (8.5 & 9.1.2)
- Replies: 7
- Views: 5836
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...
- Wed Jan 11, 2017 3:05 pm
- Forum: General
- Topic: Oracle Connector in multiple clients (8.5 & 9.1.2)
- Replies: 7
- Views: 5836
- Sat Sep 28, 2013 2:32 am
- Forum: General
- Topic: Information Server 8.5 - Installation Error
- Replies: 2
- Views: 3938
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...
- Thu Aug 22, 2013 12:26 am
- Forum: General
- Topic: Information Server 8.5 - Installation Error
- Replies: 2
- Views: 3938
Information Server 8.5 - Installation Error
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...