Search found 364 matches
- Thu Dec 11, 2008 12:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Buildop: Dropping component because of a prior component
- Replies: 7
- Views: 5461
Re: Buildop: Dropping component because of a prior component
I think you might be using auto transfer of columns, do it programatically in the loop logic.
- Thu Jul 31, 2008 9:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterprise stage
- Replies: 12
- Views: 7295
- Wed Jul 30, 2008 10:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterprise stage
- Replies: 12
- Views: 7295
There's a trick way of doing this. In the job, do a read from the same database where the table to be deleted exists and do a 'select 1 from dual' and write your table truncate/delete copmmand in the open command there and then device a dummy lookup with the actual stream of data on this dummy colum...
- Wed Jul 30, 2008 10:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execution of Job on a config file with 4 nodes
- Replies: 3
- Views: 2134
Re: Execution of Job on a config file with 4 nodes
You have to define multiple "pools" in your configuration file.
- Fri Jul 25, 2008 2:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: delete orphan dataset
- Replies: 6
- Views: 4597
- Fri Jul 25, 2008 1:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: verical pivot with max input rows unknown
- Replies: 6
- Views: 4459
Re: verical pivot with max input rows unknown
Check out the keychange columns generated in the sort stage. They will help you to identify when you move from one key record group to the next.
- Fri Jul 25, 2008 1:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Writing Nulls to Sequential File
- Replies: 7
- Views: 4631
- Fri Jul 25, 2008 12:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Command activity
- Replies: 7
- Views: 4223
- Fri Jul 25, 2008 12:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Command activity
- Replies: 7
- Views: 4223
- Fri Jul 25, 2008 12:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Writing Nulls to Sequential File
- Replies: 7
- Views: 4631
- Fri Jul 25, 2008 11:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing Timestamp as a parameter value
- Replies: 9
- Views: 6006
Re: Passing Timestamp as a parameter value
Hmmm, I am running out of ideas, but let us do one thing. a> In the sequence where you pass the parameter value to the job, just hardcode the timestamp value and run, if this works then surely the problem is on the sequence side and do point b. If this failed do c. b> Check what is being sent to the...
- Fri Jul 25, 2008 11:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting decimals
- Replies: 3
- Views: 2519
- Fri Jul 25, 2008 11:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing Timestamp as a parameter value
- Replies: 9
- Views: 6006
Re: Passing Timestamp as a parameter value
Do only a cat (the -n option will list with record numbers which you don't want). Use this:
and in ereplace, make sure there is no space between the single quotes.
Code: Select all
cat <path name>/<filename>
and in ereplace, make sure there is no space between the single quotes.
- Fri Jul 25, 2008 10:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing Timestamp as a parameter value
- Replies: 9
- Views: 6006
Re: Passing Timestamp as a parameter value
Ok, please provide the following:
1> The contents of the file
2> The commands (exact) used in the execute command stage and while passing to the job
1> The contents of the file
2> The commands (exact) used in the execute command stage and while passing to the job
- Fri Jul 25, 2008 10:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing Timestamp as a parameter value
- Replies: 9
- Views: 6006
Re: Passing Timestamp as a parameter value
Give this a try, use this derivation in the sequence when passing the parameter to the job:
Code: Select all
Ereplace(Link.$CommandOutput,@FM,'')