Search found 6 matches

by hosti2011
Wed Sep 14, 2011 11:13 am
Forum: DFSORT , ICETOOL & Utilities
Topic: concacenate strings
Replies: 2
Views: 3029

concacenate strings

Hi, i read a pli data file and want to replace values in null fields of db2 by '? 'depending on the indicator field. For this purpose i use the findrep clause: OUTREC IFTHEN=(WHEN=INIT, FINDREP=(STARTPOS=71,ENDPOS=81, IN=C' 0?', OUT=C'? ?')), that should mark the input field as conta...
by hosti2011
Sat Sep 10, 2011 11:15 am
Forum: DFSORT , ICETOOL & Utilities
Topic: ALTSEQ and german special characters
Replies: 9
Views: 9770

Hello Frank, with your infos i understand the behaviour of the job. now i have to contact the syncsort support or ask for the installation defaults of the running syncsort version. meanwhile i have to do the workaround with setting each german special character manually in the altseq table. thank yo...
by hosti2011
Fri Sep 09, 2011 10:38 am
Forum: DFSORT , ICETOOL & Utilities
Topic: ALTSEQ and german special characters
Replies: 9
Views: 9770

Things are working excpectet, despite of the fact that the german special characters are changed from e.g. ü to u when INREC the character fields with the TRAN=ALTSEQ CODE with the (00,40) Table.
i have tried in on an german mainframe installlation with syncsort version 1.4.
by hosti2011
Thu Sep 08, 2011 11:20 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: ALTSEQ and german special characters
Replies: 9
Views: 9770

again

sorry for the misunderstandable files. i had problems to paste them correct into the message. the input file was FB 80. same as the output. and in the output file the hex 00 in the records with beginning österreich are changed to blanks, as it is considered. is there a way to implement screenshots a...
by hosti2011
Thu Sep 08, 2011 12:59 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: ALTSEQ and german special characters
Replies: 9
Views: 9770

Hello Frank, thank you for your reply. Here are the details of my Problem. I insist to change low values in the input file to blanks, as in the input file there exist low values in char-fields from the unload from DB2, in case of nullvalues. INPUT DATA BAYERN MÜNCHEN REST CCECDD44440D5DCCCD44400000D...
by hosti2011
Sun Sep 04, 2011 12:28 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: ALTSEQ and german special characters
Replies: 9
Views: 9770

ALTSEQ and german special characters

Hello, i am using dfsort to create a csv-file from a file in PL/I format. the source file is from DB2. In some datafields there occurs hex X'00' in the pl/I file, in case of original value in the db2-table was NULL. I want to change the x'00' into x'40'. For this purpose i used the ALTSEQ CODE (0040...