writing High Values into Asci or Binary File

eyabmo_rbc · Post by **eyabmo_rbc** » Fri Mar 14, 2008 1:04 pm

How do i assign a column with a high value ,, if my output column is col1 , part of asci or ebcedic file ?

thanks

ray.wurlod · Post by **ray.wurlod** » Fri Mar 14, 2008 5:20 pm

What is your job design? What stage types are you using? Under what conditions do you need to assign a "high value"? Have you decided what "high value" means/is for each of the data types you are using?

eyabmo_rbc · Post by **eyabmo_rbc** » Mon Mar 17, 2008 7:25 am

ray.wurlod wrote:What is your job design? What stage types are you using? Under what conditions do you need to assign a "high value"? Have you decided what "high value" means/is for each of the data types you are u ...

Parallel job reading data from Asci file , use a transformer , write data back into a DS and an asci file , columns am reading is suppose to take high value as a default value , one of the columns is character and the other is Decimal .

thanks

ArndW · Post by **ArndW** » Mon Mar 17, 2008 7:31 am

"high" and "low" values are a COBOL concept - is this data going back to COBOL? You will need to check what the EBCDIC "HIGH VALUE" is and either use that value in a binary field, or use the appropriate ASCII mapping for a non-binary one so that when the file is converted back to EBCDIC those values are correct.

eyabmo_rbc · Post by **eyabmo_rbc** » Mon Mar 17, 2008 7:36 am

ArndW wrote:"high" and "low" values are a COBOL concept - is this data going back to COBOL? You will need to check what the EBCDIC "HIGH VALUE" is and either use that value in a binary field, or use the appropria ...

We will have both scenarios , first output will be used for our load , so , what would be the equvilent " High value " to a field in asci file ?
second file will be used by another group , they need it in a cobol equivalent , just to make it simple for you ,, what is the " High Value " equivalent in a Dataset or asci file , if the column is char or decimal

ArndW · Post by **ArndW** » Mon Mar 17, 2008 7:40 am

DataStage has no knowledge of "HIGH VALUE" - it is a COBOL concept. In most cobol implementations a PIC(X) high value is 0xFF but I seem to recall that there are differences depending on the COBOL implementation. ANSII Standard would be 0xFF. I can't recall what is used for COMP-n data types, I don't have an ANSII book available here.

I think an EBCDIC 0xFF is normally not defined and might be transferred to ASCII unchanged. In that case the value would remain CHAR(255). Try it and tell us if that is the case.

infranik · Post by **infranik** » Wed Jan 21, 2009 8:56 am

(I am continuing this thread as I didnt want to open a new one..hope no one minds)

I am able to get perfect high values and low values through a server job using function - char(255) and char(0)
but when I try to use the same in parallel jobs, I am unable to achieve the same result. (using sequential file, binary data format and EBCDIC character set) I can get low values but cannot get high values.

does anyone know how to get high values in a parallel job?