Hi,
Use the below function to get all the characters before the first "_" in a column
Field(Column_Name,"_",1)
It might work.
______________________________________________________
Sreeni
Search found 29 matches
- Wed Aug 08, 2012 3:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extract substring
- Replies: 10
- Views: 6313
- Wed Aug 08, 2012 3:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extract substring
- Replies: 10
- Views: 6313
- Wed Aug 08, 2012 3:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Loading two or more files in a single job run
- Replies: 7
- Views: 3328
- Tue Aug 07, 2012 2:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to find minimum value in a column using transformer?
- Replies: 11
- Views: 6295
- Tue Aug 07, 2012 12:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to find minimum value in a column using transformer?
- Replies: 11
- Views: 6295
- Tue Aug 07, 2012 12:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Abort Job when no files found (Extrnal Source Stage)
- Replies: 5
- Views: 3619
- Tue Jul 24, 2012 5:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential file reading with ~# delimiter
- Replies: 6
- Views: 2894
- Mon Jul 16, 2012 5:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to delete datasets created?
- Replies: 6
- Views: 3131
- Mon Jul 16, 2012 1:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to delete datasets created?
- Replies: 6
- Views: 3131
- Fri Jul 06, 2012 6:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trailer
- Replies: 1
- Views: 892
Trailer
Hi experts,
I have 10 textfiles.Each File has a Column_Total in its Trailer.Different columns are used to calculate for Column_Total in every file.How can we check the Column_Total in Datastage by a common job for all text files.
can anyone suggest regarding this?
Thanks in Advance,
sri
I have 10 textfiles.Each File has a Column_Total in its Trailer.Different columns are used to calculate for Column_Total in every file.How can we check the Column_Total in Datastage by a common job for all text files.
can anyone suggest regarding this?
Thanks in Advance,
sri
- Wed May 30, 2012 7:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Stage Inserted once,Rejected once.
- Replies: 6
- Views: 2582
- Tue May 29, 2012 7:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Stage Inserted once,Rejected once.
- Replies: 6
- Views: 2582
Oracle Stage Inserted once,Rejected once.
Hi Experts, In my job we are capturing changes in the Current file against an Empty file. Here all the records are new records and i am populating these records to Oracle Table.All the records are inserted into Oracle table. Now,We are using a new current file against the Empty file to captures the ...
- Thu May 24, 2012 3:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change Capture Warning
- Replies: 1
- Views: 1453
Change Capture Warning
Hi, I am getting below warning when i am using the Change Capture stage. "Change_Capture: When checking operator: Defaulting "Column_Name" in transfer from "beforeRec" to "outputRec". What is the reason for it? Please anybody help me to resolve it. Thanks in advanc...
- Fri May 18, 2012 1:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sqlcode "-1"
- Replies: 1
- Views: 1492
sqlcode "-1"
Hi,
I am facing the problem with sqlcode="-1" while updating the records with upsert mode in Oracle stage.
Please help me to reslove this issue.
Thanks in advance,
Sreeni
I am facing the problem with sqlcode="-1" while updating the records with upsert mode in Oracle stage.
Please help me to reslove this issue.
Thanks in advance,
Sreeni