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