DSXchange

hi guyz,

How can I remove the '/' from a date field in a transformation.

thanks

sorry, I was little excited to the fact that I was able to answer one question..

Can this be achieved this way.

convert the excel file as csv, ftp the file to a file path on the UNIX both, then read the file as a source file with sequential file stage..

can I just put '000' for Quote character?

Hi Guys, my requirement is to create a target file with 1. The first line should be column names - for this I can check the "Fist Line is column names" check box on the format tab of Inputs 2. The columns have to ve pipe delimited - for this I can out a '|' character in the space provided ...

Hi, My project has this SAP as the source system and the source data file has 100+ columns. This is an integration project between different systems, the order of the SAP source structure is not fixed(or completely determined at this poitn) until their build is complete. My DataStage first job has t...

Write the rejections to 2 different file and 'cat' these 2 files to one file in the After job routine.

Using the link collector may grow the size of the job template/canvas

hi guys, my project is to integrate the data between different target systems using DataStage One of these target systems will return the same data that I sent to it with one extra column being appended in the end. This target system uses scheduler functionality of AutoClass. Can you help on how Aut...

Ray, can you please point me to the on-line help link.
Thanks a ton

thanks chulet.

so I have been using the basic code in my transformations without really knowing that it is BASIC.

So, this is more of like a machine level language, that means, DS runs on the BASIC compiler?

also, from what I got from ue lines, the string manipulations, and all kinds of transformations we do in DS are indirectly BASIC code, right?

thanks for ur reply

Hi guyz, I am new to DataStage, cross platformed from the legacy systems to the ETL. I am using the 7x and all my jobs are server, I guess this is due to the fact that the client shop do not have more than 1 node. Now, what is Basic code in DataStage and what is the need to this. I heard some people...

does that make it fixed width columns?
Also, I do not want the quote character.

Hi, I have to create a target file with fixed width column, but each column has to be seperated by a comma(target system requirement). If I check the 'Fixed-width column' box on the inputs/format tab, the delimiter and the quote character will disabled. Can you suggest on how to get thru this . Usin...

Thanks a lot, but I am not allowed to write my own scripts without the prior approval, so i am trying to find a way to execute multiple commands from the job parameters.