Search found 6 matches

by netgurutoo
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...
by netgurutoo
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
by netgurutoo
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
by netgurutoo
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

I think the documentation is part of every install. Just go to programs from the start menu then IBM Information Server... ? Documentation.... If that option is not in the programs menu you can just click on the Help button in any stage properties page or tab... that will get you some documentation
by netgurutoo
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...
by netgurutoo
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.