hello naveen.,
thanks a lot is working.. :D
Search found 19 matches
- Tue Aug 30, 2005 2:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: left padding with zeros
- Replies: 5
- Views: 13423
- Tue Aug 30, 2005 1:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: left padding with zeros
- Replies: 5
- Views: 13423
left padding with zeros
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 ...
- Tue Aug 30, 2005 12:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: left padding with zeros
- Replies: 5
- Views: 13423
left padding with zeros
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...
- Wed Aug 17, 2005 3:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DaysSinceFromDate function
- Replies: 3
- Views: 7050
Hello
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...
- Wed Aug 17, 2005 1:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DaysSinceFromDate function
- Replies: 3
- Views: 7050
DaysSinceFromDate function
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...
- Fri Jul 22, 2005 2:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: date conversion
- Replies: 27
- Views: 10886
date conversion
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
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
- Thu Jun 23, 2005 5:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: shell script
- Replies: 7
- Views: 4372
Re: Shell Script
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
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
- Wed Jun 22, 2005 3:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: shell script
- Replies: 7
- Views: 4372
Re: shell script
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...
- Wed Jun 22, 2005 2:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: shell script
- Replies: 7
- Views: 4372
shell script
Hello craig.,chulett wrote:There's one here.
if you have a sample shell script then can you please please provide me.
it will be a great help to me.
thanks
kevin
- Wed Jun 22, 2005 2:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: shell script
- Replies: 7
- Views: 4372
shell script
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...
- Mon May 23, 2005 9:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting Fixed width flat files to ASCII format
- Replies: 1
- Views: 1096
Converting Fixed width flat files to ASCII format
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
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
- Thu May 19, 2005 7:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: hello
- Replies: 2
- Views: 1720
hello
HELLO
- Thu Apr 14, 2005 6:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: shell script
- Replies: 4
- Views: 2320
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...
- Wed Apr 13, 2005 12:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: shell script
- Replies: 4
- Views: 2320
shell script
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...
- Mon Apr 04, 2005 4:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SEquential file errors
- Replies: 2
- Views: 2156
SEquential file errors
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",...