Search found 77 matches
- Wed Aug 24, 2011 1:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Search word
- Replies: 3
- Views: 2556
Re: Search word
There are many simmilar combination. But to get a efficient idea related to above comination would more then enough to progress on rest.
- Wed Aug 24, 2011 12:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Search word
- Replies: 3
- Views: 2556
Search word
Can you suggest any idea on below requirement The below criteria/keyword i want to search from a text field/column coming from source. 1)C/O 2)C / O 3)C.O 1)COMPANY 2)C O M P A N Y 3)C.O.M.P.A.N.Y -I want to find out all records where any of these combination would be there. -Both key word should be...
- Tue May 10, 2011 6:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date convertion
- Replies: 3
- Views: 3062
Date convertion
Can anyone please through some light on converting DD/MM/YYYY format to YYYY-MM-DD format in PX?
- Thu Mar 31, 2011 11:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: field function
- Replies: 3
- Views: 2767
- Thu Mar 31, 2011 6:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: field function
- Replies: 3
- Views: 2767
field function
Can anyone give me the correct Field function syntax please?
e.g
my req is to extrac "ASIA EUROPE" from a string. I am using below code
Lnk[Index(SurrFileslnk.COL1, "ASIA EUROPE", 1),256], " ", 1, 1)
but seems someting wrong with above
Please suggest
e.g
my req is to extrac "ASIA EUROPE" from a string. I am using below code
Lnk[Index(SurrFileslnk.COL1, "ASIA EUROPE", 1),256], " ", 1, 1)
but seems someting wrong with above
Please suggest
- Fri Feb 11, 2011 2:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String extract
- Replies: 13
- Views: 7084
- Fri Feb 11, 2011 3:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String extract
- Replies: 13
- Views: 7084
- Thu Feb 10, 2011 12:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String extract
- Replies: 13
- Views: 7084
String extract
Hi Anyone have any thought on this? I want to retrieve a text from a column on below logic. Need to retrive the text start at position 2 characters after keyword "ABC=" till 5 byte or untill a space encountered e.g: SourceCol AHHHNSHHBDHHHSSSUSHUSUUSABC=TESTTTHHSHST output should be - STTT...
- Thu Oct 14, 2010 4:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join stage warning
- Replies: 1
- Views: 2491
Join stage warning
Can anyone put a quick light into it. Looked into existing entries but didnt really satisfy with those I am having an issue in below point of a join stage (warning below) XML stage ---> Transformer ---> Join stage In transformer: Preserver partitioning = clear In Output tab = Preserve sort order(Ena...
- Tue Aug 24, 2010 7:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null in update where clause
- Replies: 13
- Views: 6516
- Mon Aug 23, 2010 8:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null in update where clause
- Replies: 13
- Views: 6516
- Mon Aug 23, 2010 2:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null in update where clause
- Replies: 13
- Views: 6516
- Fri Aug 20, 2010 9:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null in update where clause
- Replies: 13
- Views: 6516
Null in update where clause
Can we update a record if where clause having a column which getting NULL from souce and having null as existing value in table for that record e.g UPDATE <TABLE> SET COLUMN3=ORCHESTRATE.COLUMN3 WHERE (COLUMN1=ORCHESTRATE.COLUMN1 AND COLUMN2=ORCHESTRATE.COLUMN2) Source COL1 COL2 COL3 1 NULL 200 Targ...
- Wed Aug 11, 2010 3:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 stage Write method
- Replies: 5
- Views: 2825
- Wed Aug 11, 2010 2:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 stage Write method
- Replies: 5
- Views: 2825