Search found 78 matches
- Tue May 19, 2009 3:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: use of Variables in the query part of ODBC stage
- Replies: 4
- Views: 2010
Re: use of Variables in the query part of ODBC stage
Use a job sequence, and call your job using a job activity. Write a routine/script to get the value from the file, use a user variable/or command activity before the job activity calling your job. Pass the user variable, which is your date time stored in file, to a job parameter (say DTTM). now you ...
- Wed Mar 18, 2009 5:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using sequence job to read multiple files of directory
- Replies: 18
- Views: 14550
Re: Using sequence job to read multiple files of directory
Hi Barbara, If you can use a a "USer Variable" stage followed by the Start Loop activity and execute the command ls -lt|head -1... you should get only one file name from the list of all files. For getting the file name you may have to write a small routine which calls DSExecute command and...
- Mon Mar 09, 2009 11:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: need help in understanding the seq file pattern reading
- Replies: 2
- Views: 1901
Re: need help in understanding the seq file pattern reading
I never thought about this scenario before.But, my guess would be it should discard the file.
Need to simulate it to get the confirmation though.
Need to simulate it to get the confirmation though.
- Sun Mar 08, 2009 4:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup character strings
- Replies: 17
- Views: 8930
Re: Lookup character strings
if i have understood your question correctly, you are trying to pull out data from the first file depending on values in lookup file (e.g. 'ab'). how many columns the first file has. if its limited (3,4) you can have a join stage joining both the files with equating lookup file column with all the c...
- Thu Aug 28, 2008 12:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Header and Trailer for FilePattern
- Replies: 4
- Views: 2630
- Mon May 19, 2008 11:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Inserting data into nested tables in oracle 10g
- Replies: 3
- Views: 2701
- Sun May 04, 2008 10:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Record CustomPX_1 on file DS_STAGETYPES cannot be written
- Replies: 3
- Views: 2733
It looks I have permission to write in DS_STAGETYPES. Following is the output of the ls command. -rwxrwxr-x 1 dsadm dstage 26624 2008-05-05 14:15 DATA.30* -rwxrwxr-x 1 dsadm dstage 10240 2008-04-24 12:22 OVER.30* -rwxrwsr-x 1 dsadm dstage 0 2007-08-28 17:22 .Type30* Can there be any other reason? Th...
- Sun May 04, 2008 8:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Record CustomPX_1 on file DS_STAGETYPES cannot be written
- Replies: 3
- Views: 2733
Record CustomPX_1 on file DS_STAGETYPES cannot be written
Hi All I am trying to create a Custome operator (CustomPX_1) in DS Manager. While Saving the detail it gives the following error. Record CustomPX_1 on file DS_STAGETYPES cannot be written Is there any issue with the access for my user ID. Do we need manager access for creating New Parallel Stages?
- Fri May 02, 2008 12:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: File nane with date
- Replies: 25
- Views: 14381
- Thu May 01, 2008 10:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reject link in a shared container
- Replies: 1
- Views: 1693
Hi splayer, 1.Using Reject Link Inside Container: First you exactly need to know what you are looking for. If you are looking for both 'Condition Not Met' and 'Reject fail' records to go in the reject stream, use both condition and Lookup failure constraints as 'Reject'. Otherwise if the intention i...
- Wed Apr 30, 2008 3:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Job Optimization for multi-processor systems
- Replies: 6
- Views: 4159
- Tue Apr 29, 2008 1:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: orchestrate fatal error
- Replies: 7
- Views: 6700
- Mon Apr 28, 2008 10:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Setting User Status of Job Activity
- Replies: 2
- Views: 3172
Why would you like to set the job status in Job activity? If you want to pass different statuses, when the Sequence is called at separate instances, you can make a provision of a Job Parameter in the job and write a job control routine or before routine to update the job status to the value in the p...
- Mon Apr 28, 2008 9:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compiled Date in DataStage Repository
- Replies: 10
- Views: 11239
- Mon Apr 28, 2008 8:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compiled Date in DataStage Repository
- Replies: 10
- Views: 11239
Hi Ray, I did SELECT * FROM DS_JOBOBJECTS WHERE @ID LIKE '%<JobId>%' AND OBJNAME LIKE 'ROOT%' The answereset is Object type........ J Object record id... 13 Object record name. ROOT Description........ There is not Date displayed here. Again, I couldnot find any Date column in DS_JOBOBJECTS table. A...