1
  • Sum of integer in table with .dbf format

    I have table with .dbf format..inside only have 30 records which are 239,45,340,...etc. I wan to sum the integer like this..for example the first number..239=2+3+9=14..and the second number 4+5=9..then the output is 14,9,...until the 30th number..How would i do it? Help is desperately needed..I...

    Quinten15 pointsBadges:
  • 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...

    Piano510 pointsBadges:
  • 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...

    Rick53110 pointsBadges:
  • 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?

    BGramby15 pointsBadges:
  • 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.

    Antgaudi5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following