DSXchange

Hi Guys, We found a workaround for the problem w/ the following way. 1.) Added the column names on first line, increased field length to conform to this. The first line with the column names now contains the question mark character. 2.) Set the Target Sequential File to First Line Column Names = Fal...

Hi, We copied the file to the FTP Server without any suspicious characters (20150615), format is in UTF - 8. Then when the FTP Stage reads it the question mark appears. So we tried to copy the file again from FTP to local path. And the result becomes like this 20150615 (there is a dot on the middle...

Hi Ray, do you have any idea on how can I remove this?
We have tried the Strip BOM = true function on the sequential file but it is not removing the leading question mark.

Thank you very much.

Hi, I have a file which is encoded in UTF-8 and has EOL = CR/LF. When we are reading this file on the FTP server, the first row, first column data has a leading question mark. Can anyone help what is causing this problem. Sample Data: ?2015061 abcdefg 20150616 efghijkl 20150617 mnopqr Other info. NL...

Hi chullet, Can you give me the link of the site for the "Date Math" Routines by ray so I can browse it. Hi FranklinE, I will have to confirm this, but my understanding is that we use this date to keep track on changes of the file. For example: On the FTP Server, The File is named, file.tx...

Hi FranklinE,

Sorry if it is not clear.

We use the date on that control file as an extension to names of text files that we are going to extract.

For Example,
/path/filenameyyyymmdd.TXT
where yyyymmdd is the date from control file.

Hope this helps.

Hi, Thank you for your reply rkashyap.

What do you mean by a job to trap 'user variable'? Can you please advice .

Ahm regarding as to why the control file is a sequential file rather than database I dont really know but its the requirement given to us.

Hi, I have a sequential file which contains a date 20150812 We read it on a sequence job using execute command and pass it on to a user variable activity then to our sequence job so that our job can get its value. My question is it is possible to increment this date and taking to account valid dates...

Hi ray,

Is there an option on looping on transformer stage available. We are currently using Datastage 8.1

Thanks.

Hi Everyone, I have a stream of data that looks like this col1|col2|col3|col4|col5 Null|Inconsistent|Valid|Valid|Valid Valid|Valid|Valid|Valid|Valid Null|Valid|Valid|Valid|Valid Valid|Inconsistent|Valid|Valid|Valid Now our problem is on the transformer stage we do a constraint which when Column is n...

Can i use Len($variable) = 0 to validate?

Hi Everyone,

Is it possible to check if an environment variable or a parameter is null? Because on job properties variables dont have nullability option.

Hope you can help me.

Thanks.

Will this also work for Integer datatype?

Thank you.

Hi Everyone,

I have a timestamp column and I wanted it to become a number with format yyyymmdd on the output of a transformer stage. Can anyone suggest method on obtaining this.

Thank you very much.