Search found 103 matches

by sagar deshmukh
Wed Dec 31, 2008 11:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage not identifying Varchar
Replies: 14
Views: 5826

My datastage job will read the REJECT:CODE generated then it will abort if REJECT:CODE is available.
by sagar deshmukh
Wed Dec 31, 2008 11:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage not identifying Varchar
Replies: 4
Views: 1099

DataStage not identifying Varchar

Hi i have a rounine as given below DEFFUN ConvDateCYYDDDtoYYYYMMDD(A) Calling "DSU.ConvDateCYYDDDtoYYYYMMDD" DEFFUN ConvDateToYYYYMMDD(A) Calling "DSU.ConvDateToYYYYMMDD" DEFFUN ConvtSignOverPunch(A) Calling "DSU.ConvtSignOverPunch" ****** *Init* ****** RECORD_LENGTH = ...
by sagar deshmukh
Wed Dec 31, 2008 11:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage not identifying Varchar
Replies: 14
Views: 5826

DataStage not identifying Varchar

Hi i have a rounine as given below DEFFUN ConvDateCYYDDDtoYYYYMMDD(A) Calling "DSU.ConvDateCYYDDDtoYYYYMMDD" DEFFUN ConvDateToYYYYMMDD(A) Calling "DSU.ConvDateToYYYYMMDD" DEFFUN ConvtSignOverPunch(A) Calling "DSU.ConvtSignOverPunch" ****** *Init* ****** RECORD_LENGTH = ...
by sagar deshmukh
Tue Dec 23, 2008 4:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to read a Tab delimited file Using FTP stage
Replies: 1
Views: 1473

How to read a Tab delimited file Using FTP stage

Hi i need to read the Tab delimited file which is a .txt file. using a FTP stage.

can you please suggest me how do i need to set the delimiter?
by sagar deshmukh
Sat Dec 13, 2008 12:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to remove box character insequential file
Replies: 17
Views: 7960

what exactly i am doing is...i need to read a CSv file, from a remote server to a sequential file, i tried using all the mappings of NLS...I am using FTP stage , in the line ternmination i am using is LF(unix) and the same line termination am using in sequential stage..., but the output is cooming l...
by sagar deshmukh
Fri Dec 12, 2008 7:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to remove box character insequential file
Replies: 17
Views: 7960

i dont have premium membership so i cant read ur post thats y i asked to end it on my mail ID
by sagar deshmukh
Fri Dec 12, 2008 7:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to read a CSV file from remote server by using FTP stag
Replies: 4
Views: 1991

can you please mail me the sulution to sagarddd@gmail.com please.
by sagar deshmukh
Fri Dec 12, 2008 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to remove box character insequential file
Replies: 17
Views: 7960

i belive because of space the box character is comming just need to know the solution how to remove that
by sagar deshmukh
Fri Dec 12, 2008 7:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to remove box character insequential file
Replies: 17
Views: 7960

how to remove box character insequential file

i am reading a cvs file into a sequential file. but i am getting box character in the output.please let me know if i need to apply any setting for this. :idea:
by sagar deshmukh
Fri Dec 12, 2008 7:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need help
Replies: 3
Views: 1663

well the NLS setting is UTF8, we are using...
by sagar deshmukh
Fri Dec 12, 2008 5:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to read a CSV file from remote server by using FTP stag
Replies: 4
Views: 1991

Need to read a CSV file from remote server by using FTP stag

Hi i have a CSV file as below ' '90028' 10: ADULT BB1' '12/08/2008' 10:54:02' '0000062744001' '0.95' '1' ' '90028' '10: ADULT BB1' '12/08/2008' 10:54:02' '0000062744002' '0.95' '1' '' '90028' '10: ADULT BB1' 12/08/2008' I need to read it from remore server. please let me know what setting i need to ...
by sagar deshmukh
Thu Dec 11, 2008 6:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need help
Replies: 3
Views: 1663

Need help

Am using FTP stage to get data from Remote File, residing on remote server,I am reading data from an CSV file, and writing it to a sequential file, :twisted: So am getting below error...please help me ..... ERROR srcRecon_LN..xfmCPST: Function, convertRBufToUTF() error: Unable to map data to interna...