DSXchange

Hi, I have sequencer where i have to check for file existence then proceed further.I have used execute command activity and used test -e in command and passed parameter #filename#.But the job is showing a warning message and job is not detecting the file. I have used return value =0 for file existen...

Fixed with implies no column delimiter at all. NUL occupies one byte. Therefore your proposed approach is not generically valid. Read each line as a single VarChar column and parse it within a Tr ... Ray, Let me explain: Sample data file looks like: HEADER 000000000000005 0105610095600ABX MANAGEMEN...

Hi,

We have a cobol file defintion with column having PIC 9(20).When i try to import this definiton it is showing an error:

PIC Numeric is too long (number of precision and scale is allowed up to 18)

Please advice!

Ray,

I have given col delim,quote char as NUL and Escape char as SPACE.

The data on remote server is now:
NHEADNNER NN 000000000000004

Instead of HEADER 000000000000004.

Hi, I have a file with header ,trailer and detail records.The header record length is 10 ,trailer record length is 15 and detail records are fixed width length of 50. I'm currently working on ftp stage to do this.I have tried reading the file as fixed width then on remote server the file is created ...

dspxlearn ,

I have not used px jobs for reading xml.I was unable to find where can we mention input file name in xml input or xml transformer stages.Just curious to know..

deesh wrote:Previously ididnt work on XML Who knows the XML files in Enterprise Edition PX can you provide the suggestion

Use server job.Folder stage-->xml input file-->target.

Thankyou.

It is working now.I have used:

DataTypePicS9(Ebcdic(Lnk_Trns.DEDUCT_AMT))

Thankyou.

It is working now.I have used:

DataTypePicS9(Ebcdic(Lnk_Trns.DEDUCT_AMT))

Thanks for your advice.

Is there any possible way of converting COMP fileds to decimal or interger values.

Hi, I have a simple server job which loads data from file to database.The file is ftped from mainframe to windows server.The problem is the values for input double columns is coming as 0000000{0000000{0000000{0001000. The length of each field is 8.The job is getting failed because of } in the data. ...

Verify your metadata.It may be the problem.Also in the format tab add delimiter,final delimiter as none.

The column FIELD is declared as char(10).I have got the buffer overrun on several rows.

I have got table definition from database which send the data to Mainframe.I'm using the files ftped from Mainframe.


Please advice!

Thanks!

Hi, I'm reading fixed width file.I used record length is Fixed and delimiter none.And Packed as no(overpunch). For all decimal fields i have mentioned field width by editing the row. I'm not able to view the whole data.Some of the records are getting rejected when i run the job. Sample of the data i...

Ray,

I have modified my code to CONVERT(char(012),char(032),trim(field name)) instead of CONVERT(char(010),char(032),trim(field name))

And now it is displaying in a single row.

Thanks!