Search found 155 matches
- Tue Feb 26, 2013 3:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Co Sort functionality using Datastage Generic Job
- Replies: 2
- Views: 2593
Co Sort functionality using Datastage Generic Job
I am currently working in a datastage migration project 7.5 to 8.5 As part of code migration process we have 1000s of CoSort scripts also which needs to be migrated to the new Linux server. To avoid licensing cost for CoSort the plan is to convert the CoSort scripts in Datastage Parallel jobs. Strat...
- Sun Feb 12, 2012 12:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: soundex field name in schema
- Replies: 4
- Views: 3767
- Wed Feb 08, 2012 9:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: soundex field name in schema
- Replies: 4
- Views: 3767
soundex field name in schema
we are using a generic job for loading the data from sequential file to a teradara(using RCP and schema file). In our schema file we are having a field as "soundex" which has to be mapped to the target teradata table "soundex". we can able to create the table in teradata by putti...
- Thu Dec 15, 2011 3:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insertion of Null Character at position 4095 in File
- Replies: 9
- Views: 6045
- Thu Dec 15, 2011 1:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insertion of Null Character at position 4095 in File
- Replies: 9
- Views: 6045
- Wed Dec 14, 2011 9:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insertion of Null Character at position 4095 in File
- Replies: 9
- Views: 6045
- Wed Dec 14, 2011 8:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insertion of Null Character at position 4095 in File
- Replies: 9
- Views: 6045
Insertion of Null Character at position 4095 in File
My Job is creating a Fixed Width which is having record length of 4703. The file is created successfully with some NULL Character at positon 4095. I thought this might be coming from the Source table(Oracle) but i didn't find it any there.There is a field COB_COMMENT which is spread across 4095. I h...
- Thu Dec 08, 2011 7:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Mutiple Links to Parallel Transformer stage -- SHOCKED ???
- Replies: 5
- Views: 5564
In the same job i cannot able to add any more extra links to the transforner stage... and i have copied that stage and pasted in another new job still i cannot able to add any links to it... which is veru weird... And Ray, the transformer stage name has been renamed... so on the title bar it's given...
- Wed Dec 07, 2011 10:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Mutiple Links to Parallel Transformer stage -- SHOCKED ???
- Replies: 5
- Views: 5564
- Wed Dec 07, 2011 4:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Mutiple Links to Parallel Transformer stage -- SHOCKED ???
- Replies: 5
- Views: 5564
Mutiple Links to Parallel Transformer stage -- SHOCKED ???
I am in a production support cum enhancment project where i came across few datastage(version 7.5) PARALLEL jobs which is having multiple links to the transformer stage. I can add multiple reference links to the transformer stage which is very strange which i found. I thought its the BASIC tranforme...
- Wed Dec 07, 2011 4:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Mutiple Links to Parallel Transformer stage -- SHOCKED ???
- Replies: 0
- Views: 1370
Mutiple Links to Parallel Transformer stage -- SHOCKED ???
I am in a production support cum enhancment project where i came across few datastage(version 7.5) PARALLEL jobs which is having multiple links to the transformer stage. I can add multiple reference links to the transformer stage which is very strange which i found. I thought its the BASIC tranforme...
- Mon Nov 28, 2011 6:17 am
- Forum: General
- Topic: Some annoying things in 8.1
- Replies: 13
- Views: 4506
- Mon Nov 28, 2011 6:11 am
- Forum: General
- Topic: Need help with shell script which calls Datastage Job
- Replies: 2
- Views: 2531
- Tue Nov 22, 2011 8:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to split a delimited string into rows?
- Replies: 9
- Views: 15926
You can write a shell script for the dynamic pivot. I have one you can use this as reference and change accordingly #!/usr/bin/ksh ########################################################################### # # # Script Name: DynamicPivot.sh # # # Input: DynamicPivot.sh {Input File Absolute Path} # ...
- Tue Nov 22, 2011 8:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Updating multiple records
- Replies: 9
- Views: 5762