Signed field to a packed field in AS/400 query
Does anyone know of a way to move a signed numeric to a packed numeric in query? Is it even possible?   Been playing with it and can’t find a way.  Any answer appreciated. 

Answer Question   |  March 15, 2011  6:39 PM
AS/400 administration, AS/400 Query, Packed Fields, Query tuning

Substring A Packed Field
Hello I have a flat record format that I move into an external data structure. Within the external data structure, I have many packed fields. Rather than refer to each of pacekd field by external field name, I would like to be able to substring each packed field out, and then, move the value of [...]

Answer Question   |  September 3, 2010  4:13 PM
Array, Data Structure to Flat File, Data structures, Flat files, Packed Fields, Substring