Search found 72 matches
- Mon Apr 28, 2008 6:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with Charachter handling in Dataset
- Replies: 10
- Views: 3556
- Thu Mar 27, 2008 4:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to catch User Defined exceptions(PL-SQL) in Director Log
- Replies: 1
- Views: 1146
How to catch User Defined exceptions(PL-SQL) in Director Log
Hello All,
I want to catch the user defined exceptions in a PL-SQL procedure and display them on Director logs, I am using a Stored procedure stage to trigger the PL-SQL code. Can this be done in datastage? Need help in this regards.
Thanks
Gokul
I want to catch the user defined exceptions in a PL-SQL procedure and display them on Director logs, I am using a Stored procedure stage to trigger the PL-SQL code. Can this be done in datastage? Need help in this regards.
Thanks
Gokul
- Fri Feb 08, 2008 3:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Capturing Oracle Error Code From Enterprise Stage
- Replies: 1
- Views: 852
Capturing Oracle Error Code From Enterprise Stage
Hi All, I have a follwing job design OraTable -------->Transformer-------->OraTable a> The source & Target are Oracle Enterprise Stages. b> There are 2 targets, one for good records and other reject table where we will have bad records. In the reject table , I want to capture the oracle error co...
- Thu Aug 31, 2006 11:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Generation of XML Header from another file
- Replies: 1
- Views: 874
Generation of XML Header from another file
We are in process of generating XML output file. <B>Process:</B> a. We have 4 sequential source files containing data to be merged into a single XML file. b. The Header for the XML file contains which comes from the 5th sequential file. The Header also contains some other information like Message an...
- Wed Mar 22, 2006 1:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem while Looking up in Distributed Hashed File
- Replies: 5
- Views: 2009
Problem while Looking up in Distributed Hashed File
Hi All, I have created a Distributed Hashed Files EMPLOYEESALL with part files as EmployeesATOL ,EmployeesMTOV and EmployeesWTOZ. Data is loaded in the hashed file EMPLOYEESALL. But when i use hashed file EMPLOYEESALL as a lookup with Pre-Load file to memory enabled or Enabled,Lock for Updates ,it g...
- Mon Mar 06, 2006 9:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Trivial(Essential) Question
- Replies: 1
- Views: 823
Trivial(Essential) Question
Hi Following are the queries related to the Sequential Stage which popped up during the debugging of a code 1.During debugging a code,we realised that the number specified in the Display column was large then the number specified in the length column of the data grid of the Sequential Stage. Due to ...
- Wed Oct 05, 2005 12:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: multi lines --> single line ?
- Replies: 8
- Views: 3005
- Tue Oct 04, 2005 11:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: multi lines --> single line ?
- Replies: 8
- Views: 3005
what type is the source is it? 1> If the source is Oracle then u can try the below query as user defined query and get the required result. select max(decode(rownum,1,dname))||max(decode(rownum,2,dname))||max(decode(rownum,3,dname)) C from dept 2> If the source is sequential and u r writing in a seq...
- Thu Sep 15, 2005 7:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Creating Static Hash file
- Replies: 5
- Views: 1692
- Thu Sep 15, 2005 6:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Creating Static Hash file
- Replies: 5
- Views: 1692
- Thu Sep 15, 2005 6:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Creating Static Hash file
- Replies: 5
- Views: 1692
Creating Static Hash file
Hi , I have created the static type 3 hashed file using command line of adminstrator. I am trying to create the hashed file through the datastage job. I have specified Type 3 in the Create file options of the target hashed file. No transformer is used in the Job . The hashed file is created from the...
- Thu Sep 15, 2005 1:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: record.ID in DELETE
- Replies: 2
- Views: 1061
record.ID in DELETE
Hi, In the Delete statement given in the supporting PDF DELETE [file.variable,] record.ID [ON ERROR statements] [LOCKED statements] [THEN statements] [ELSE statements]. What is record.ID? I tried with a file abc.txt containing one record having value "Hello". The Delete statement used to d...
- Tue Sep 13, 2005 12:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Creation of user of DataStage.
- Replies: 7
- Views: 2875
Creation of user of DataStage.
Hi,
In Datastage Administartor ,we can assign roles to the User for a specific user. Where and How can we create the Users of Datastage?
Note: This is not an interview question, i just stumbled across the question.
Thanks,
Gokul
In Datastage Administartor ,we can assign roles to the User for a specific user. Where and How can we create the Users of Datastage?
Note: This is not an interview question, i just stumbled across the question.
Thanks,
Gokul
- Thu Aug 04, 2005 7:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Determination if the Hash File Size has increased.
- Replies: 11
- Views: 4467
- Thu Aug 04, 2005 5:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Determination if the Hash File Size has increased.
- Replies: 11
- Views: 4467