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

Why doesn’t the substring of a large field in CLLE program work correctly?
I have a CLLE program in which I pass two parameters, the first is a one character field, the second is a 600 character field. When run, the parameters come in correctly. But when I substring the second parameter into 40 fifteen character pieces it gives me a CPF0804 error half way through the string. [...]

Answer Question   |  June 19, 2010  8:43 PM
CLLE, CPF errors, Substring

Concatenation
I am using “substring(concat(’00′….” within my SQL select for a date query. However, the date 10 and higher is being overridden with “0″. How do I prevent this from happening?

Answer Question   |  June 10, 2009  6:55 PM
Concatenate, SQL Query, SQL Select, Substring

UE SUBSTR or RTRIM?
I need to get cities’ name from a format like this: Los Angeles, CA New Orleans, LA etc.. I’ve tried: substr(a.air_location, -4) but that gives me the opposite…”, LA” Any suggestions? Thanks.

Answer Question   |  May 7, 2009  5:21 AM
InStr function, RTRIM, SUBSTR, Substring