mainframegurukul.com

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...

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...

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.

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...

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...

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...