DSXchange

hello naveen.,

thanks a lot is working.. :D

Hi studyguy2001, You can achieve it 1) If you use the Basic Transformer in your job, you can use the below the transformation FMT(InLink.Col1,"10'0'R") Alternatively, you can use some custom logic to check the length of the field and see how many digits it is less than 10 and concatenate ...

hello everyone., i have a coumn with 10 digits as column length. data type is integer.if they length of the column is less then 10 digits then it should be left padded with zeros untill it is 10 digits long. i have to write this entire logic in parallel transformer. i am working on DS v.7.5 can anyo...

Mark, converting an Integer date (in Julian date format?) to a date and back to an integer should give the same result. The conversion between types needs to know the source and target formats, otherwise it won't work correctly. Do you know your source date format in integer? Why do you need to con...

Hello., problem: i have a column with data type integer. it has to be converted into date and then again the date has to be converted into interger in the output. i know there is a function in datastage DaysSinceFromDate . this function can ve used to do it. does anyone has used this function before...

hello.,

i am new to datastage.

my inut date format is : YYYY-MM-DD
THE Output date format has to be : DD-MM-YYYY

can anyone please tell me how do i do it in transformer.

also can anyone please tell me how do i set flag status to either YES or NO in a transformer.


thanks
mark

Hello Everyone.,

Craig i went to the link and i saw the script.
i am now able t run my DS job using shell script you provided.

thanks a lot guys
bye
kevin

hello., i am working on parallel extender v7.5. i never write a shell script to run the datastage jobs. i normally used datastage director to run the jobs. i am new to shell scripting. can anyone please help me with a sample shell script to run the datastage job. in the shell script i also have to g...

chulett wrote:There's one here.

Hello craig.,

if you have a sample shell script then can you please please provide me.
it will be a great help to me.

thanks
kevin

hello., i am working on parallel extender v7.5. i never write a shell script to run the datastage jobs. i normally used datastage director to run the jobs. i am new to shell scripting. can anyone please help me with a sample shell script to run the datastage job. in the shell script i also have to g...

hello.,

i am working on DS v. 7.5 . source is mainframe. format is fixed width flat files. i am trying to convert the flat files into ASCII format.
i kindly request can someone please give me some ideas how i convert into ASCII format.this is very urgent.

thank you,
mark

HELLO

Do a search this has been covered a lot. Ken Bland posted a very detailed shell script to do exactly what you want. hello, thank you for your reply. when did ken bland posted the shell script or can you please tell me what is the subject under which he posted the shell script so that i will help me...

hello., i am wokring on parallel extender 7.1. i have to work on unix to do the job scheduling. but i am not too good in unix shell scripting as i was used to do only in datastage. 1) can anyone please help me with a sample shell script for job scheduling and running in datastage 2) it would be very...

hello ., i am running a job from sequential file to the ftp to mainframe using ftp stage. i am using: sequential file --- ftp after i run the job i am getting following errors: SQFS_data,0: Error reading on import: SQFS_data,0: Bad record delimiter after fixed-length record: expected "\n",...