I have tried the option like, Delimiter as comma and Quotes=Double. It solved the Issue.
Many thanks to all of You!!
Search found 52 matches
- Thu Oct 14, 2010 7:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CSV file with delimiter other than comma
- Replies: 10
- Views: 5930
- Tue Oct 12, 2010 7:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CSV file with delimiter other than comma
- Replies: 10
- Views: 5930
- Tue Oct 12, 2010 6:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CSV file with delimiter other than comma
- Replies: 10
- Views: 5930
- Tue Oct 12, 2010 3:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CSV file with delimiter other than comma
- Replies: 10
- Views: 5930
Since your problem lies in having embedded commas, you need to ensure that your strings are quoted when writing to the sequential file. CSV files do not need to have commas as separators, quite of semicolons are used and theoretically any separator could be used. what did you specify as your separa...
- Tue Oct 12, 2010 3:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CSV file with delimiter other than comma
- Replies: 10
- Views: 5930
- Mon Oct 11, 2010 10:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CSV file with delimiter other than comma
- Replies: 10
- Views: 5930
CSV file with delimiter other than comma
Is it possible to create a CSV file with the delimiter other than comma. If its possible, can anybody let me know the option to be used and the delimiter?
Thanks..
Thanks..
- Mon Oct 11, 2010 10:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Count of records processed
- Replies: 3
- Views: 1781
Add one dummy column(Value=1) while writing into datasets and group by based on that dummy coulmn to get the count. You should have a dummy column in the transformer and aggregate based on dummy column, which will give you the count of records. But what will you do if none of the records meet the c...
- Sun Sep 05, 2010 11:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Executing scripts
- Replies: 15
- Views: 7973
- Sat Sep 04, 2010 12:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Executing scripts
- Replies: 15
- Views: 7973
Give the full path to 'wc' in the script. If you still have problems, post the script and the exact, unedited error message(s) from the log. Input: wc -l TargetFilePath/FileName > Countfilepath/CountFileName Error: User logged in. Type set to A. ?Invalid command You have transferred 0 bytes in 0 fi...
- Sat Sep 04, 2010 4:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Executing scripts
- Replies: 15
- Views: 7973
- Sat Sep 04, 2010 3:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Executing scripts
- Replies: 15
- Views: 7973
- Fri Sep 03, 2010 12:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Executing scripts
- Replies: 15
- Views: 7973
How did you call the script in DataStage. Are you able to run your script and get the results outside of DataStage. Yes i can execute my script outside datastage. I am giving my script name in my user variblae in sequencer and using execute stage iam passing the parameters. The script is executing ...
- Fri Sep 03, 2010 12:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Executing scripts
- Replies: 15
- Views: 7973
Executing scripts
Hi, I have a requirement like below and iam not able to proceed any further. can anybody let me know if there is a way to do the below task. I have 5 Input files each of different metadata. I want to get the count of each file and write into a new file. I have created a script using wc -l and tried ...
- Tue Jun 22, 2010 3:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Program Sources in Manager
- Replies: 2
- Views: 1389
- Tue Jun 22, 2010 12:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Program Sources in Manager
- Replies: 2
- Views: 1389
Program Sources in Manager
Hi, I am trying to take a dsx from Manager. While selecting i will select the two options "JOB DESIGN" and "JOB EXECUTABLE" alone. We have another option called PROGRAM SOURCES under JOB EXECUTABLES, do we need to check this option. If Yes, why need to select and if not what will...