Search found 70 matches
- Thu Jul 03, 2008 9:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Decimal Issue
- Replies: 6
- Views: 3588
- Thu Jul 03, 2008 9:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Decimal Issue
- Replies: 6
- Views: 3588
- Wed Jul 02, 2008 3:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Decimal Issue
- Replies: 6
- Views: 3588
- Wed Jul 02, 2008 3:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Decimal Issue
- Replies: 6
- Views: 3588
- Wed Jul 02, 2008 2:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Decimal Issue
- Replies: 6
- Views: 3588
String to Decimal Issue
My input column is A - CHAR(9) with value of 000332422, My output should be 00.0332422.
I used a Decimal(9,7) for my output, but it writes 00.000000.
How do I resolve this?
Thanks, as always
I used a Decimal(9,7) for my output, but it writes 00.000000.
How do I resolve this?
Thanks, as always
- Tue Apr 22, 2008 5:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Target column to be populated with DS user name
- Replies: 3
- Views: 2037
- Tue Apr 22, 2008 4:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Target column to be populated with DS user name
- Replies: 3
- Views: 2037
Target column to be populated with DS user name
Hi all,
I have a requirement to populate one of the target columns with the DataStage generic user name. Can you help me how to do this?
Thanks
I have a requirement to populate one of the target columns with the DataStage generic user name. Can you help me how to do this?
Thanks
- Tue Apr 08, 2008 10:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Delete records from a Hash file
- Replies: 1
- Views: 1653
Delete records from a Hash file
Hi all, I have a situation where I have to delete records based on a key. Oracle table as the source with columns DNO - Key DNM LOC I have a Hash file with thye same column definition. I have to delete records from the Hash file based on the DNO - key, so if the Oracle table has 3 records with 10,20...
- Tue Jul 31, 2007 9:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to delete hash files from a file path
- Replies: 2
- Views: 1834
How to delete hash files from a file path
Once my sequencer job successfully finished executing the DS server jobs, I want to delete the hash files created by the process.
Can you suggest me the best way to do it.
Thanks
Can you suggest me the best way to do it.
Thanks
- Mon May 21, 2007 7:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to kill or release a DS job.
- Replies: 7
- Views: 3660
- Mon May 21, 2007 7:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to kill or release a DS job.
- Replies: 7
- Views: 3660
- Mon May 21, 2007 7:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to kill or release a DS job.
- Replies: 7
- Views: 3660
How to kill or release a DS job.
Hi,
Few of my jobs are in "use"(accessed by another user) status for more than 2 days.
How to I kill or release them from the DS Administrator?
Please suggest the command.
Thanks
Few of my jobs are in "use"(accessed by another user) status for more than 2 days.
How to I kill or release them from the DS Administrator?
Please suggest the command.
Thanks
- Sun May 20, 2007 11:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Occurs clause from the COBOL file.
- Replies: 1
- Views: 1634
Occurs clause from the COBOL file.
Occurs clause from the COBOL file. I have a input file coming from mainframe and the COBOL copybook has a table with occurs clause. The requirement is like this, Using DataStage 7.x, if the table OCCURS 2 times, I have to generate 2 rows in the output, i.e. 1 row for the first occurrence and 2nd row...
- Wed May 16, 2007 2:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: File with diff record layouts
- Replies: 1
- Views: 1389
File with diff record layouts
Hi, I have a file with different record layouts. example - record 1 is of 7 columns record 2 is of 4 columns(not all columns are same as of record 1) record 3 is of 6 columns(not all columns are same as of record 1 and record 2) and the same above set of records repeat. How can I use this file as in...
- Wed Jan 31, 2007 3:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read byte by byte in DS
- Replies: 3
- Views: 2012