DSXchange

I have tried the option like, Delimiter as comma and Quotes=Double. It solved the Issue.

Many thanks to all of You!!

I cant get my input with Quotes, its coming from many source tables and after transformations, writing into a sequential file as CSV file.

ray.wurlod wrote:Use a server job, or server Sequential File stage in a server Shared Container in a parallel job. ...

Thanks for your reply Ray...
I dont have access to use all these stages. We cant implement these stage. Is there any other way to solve the issue?

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...

In the sequential file "Format" tab, select Field defaults -> Delimiter to be a value other than the default "comma". ... If you specify other than comma, its creating file with incorrect values. Please see the example below. Input: col1 col2 col3 ABC A,B ABC Output should be li...

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..

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...

**** This first error is from an FTP session. FTP does not include a "wc " option. Newtest.txt requires a "chmod +x" to execute Does your Datastage job attempt to do a rsh to a secondary system where the script resides. The second test is a basic error in permissions. The file c...

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...

vinothkumar wrote:Try giving wc alone and see what happens.

Getting the same error even with wc

anbu wrote:Are you giving full path to the script in the sequencer job?

Yes Iam giving full path.

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 ...

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 ...

Since the dsx is really just a sequential file, you could always do two exports and examine them for any differences based on your choices. :wink: As far as I know, if you've included the "designs" then you don't need to include the program sources as they are synonymous. Seems to me that...

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...