DSXchange

Thanks craig for the pointer, However we need some generic solution like routine as we need to apply it in multiple jobs for n number of columns . I am aware that we can go for a parallel routine in C++ and use object file of that in parallel routine. Still if there is any other pointer that we can ...

Hi All, I do have a server routine which replaces all the new line characters and some special characters which i am using for each of char and varchar fields in existing design. However server routine does not work in parallel jobs also I've not used parallel routines ever but we need to implement ...

Thanks Ray and Craig for your valuable inputs. I have implemented the logic by creating routine using NUM() and Iconv with MD and its working as expected.

Thanks craig, I am trying with ICONV and MD conversion but not yet getting desired results. Meanwhile i will keep digging in it. If any other suggestions there please let me know.

Hi All, I need to validate a given string in DS server jobs. Check If the given string is decimal or not.For Parallel jobs i can use IsValid(Decimal[m,n],MyString) function in transformer stage, however in Server jobs i am not able to find anything similar to perform that. Can someone help me on tha...

hi,
i ftped file in binary mode also, but getting some transformations there also like below:
SE.SED640.NAPID!~~---> SE.SED640.NAPID]~~.X~~

in ascii mode also i was getting some transformation..but with binary mode very less number of transformations are happening but still there are some...

HI,

I FTPED that file in unix in normal mode, and when i tried reading it in unix itself i got same transformation, so that mean its getting converted during ftp only...can anyone suggest me is there any such thing can be handled while FTPing...

When i tried with FTP normal method(FTP without binary) viewing that file data in unix i can see the data but it do have ^ character also in between two columns and also don't have a proper format how will be i able to read it using sequential file stage?

What should i use ??

its a file coming from MAinframe job after SFTP and its ascii i ftped this using Normal FTP

i had used following:
byte order: Native Endian,
Data Format : Binary
Character set: ASCII
column: FORMAT_CD BINARY[4] USAGE COMP, PIC S9(4) COMP

i tried with NLS MAP=ASCL_EBCDIC also but its not working.

i had used following:
byte order: Native Endian,
Data Format : Binary
Character set: ASCII
column: FORMAT_CD BINARY[4] USAGE COMP, PIC S9(4) COMP

i tried with NLS MAP=ASCL_EBCDIC also but its not working.

i am reading file as ASCII, and yes its PIC S9(4).

i am able to view data but out of 924, 24 records are getting rejected due to above warnings but rest 900 records are going without any warning.

i have defined FORMAT_CD as BINARY [4] USAGE COMP only
its in output its as INT 4, rest all columns are CHAR not aware about the NLS map what it should be..?