Search found 6 matches
- Thu Jul 14, 2011 6:25 am
- Forum: General
- Topic: Passing commandoutput as a parameter in to the parameter set
- Replies: 14
- Views: 7739
I am not sure if this is any help but you can change values in Parametersets only in the Values files. In the Parameterset you can have many value files created in the Values tab of the parameterset. Column one is Value File Name... lets say your value file is OtherParms.txt.... all other columns ar...
- Thu Jul 14, 2011 6:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Did not reach EOF Message from Surrogate Key Generator
- Replies: 1
- Views: 1901
Re: Did not reach EOF Message from Surrogate Key Generator
Try creating a new key file. I have a job the just creates an empty .txt file
- Thu Jul 14, 2011 6:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Integer to decimal conversion
- Replies: 2
- Views: 4303
Re: Integer to decimal conversion
These are only warnings. You can use a Modify stage to change column types from Integer to Decimal. You don't need to worry about unless you have to get rid all warnings in your job. Datastage wil convert for you
- Thu Jul 14, 2011 5:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Newbie question regarding a debugger
- Replies: 12
- Views: 6949
- Thu Jul 14, 2011 5:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: creating many output files
- Replies: 10
- Views: 4694
Re: creating many output files
If you need to do this in Datastage you can simply use a jobs that use a Filter stage after the file. You can have many output files from the filter and you only need to put a where clause like ColumnA = 123, etc... (exclude the where) the trick will be keeping track of what link numbers go with eac...
- Thu Jul 14, 2011 5:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in Change Capture stage
- Replies: 2
- Views: 2742
Re: Need help in Change Capture stage
You can easily get the answer you want by looking at the developers guide You should get 4 rows Key Non_Key Change code 1 a 0 (Copy) 2 d 3 (Edit) 3 c 2 (Delete) 4 e 1 (Insert) You can make the change codes whatever you want. Above are defaults.