ODBC problem Changing Structure Table

5 pts.
Tags:
DDS
ODBC
V5R3
I have a client program conncected via odbc to AS400, I defined a structure table (DDS) in the AS400 that the client program use, then I had to change the length of numeric field (3 to 8) but the client program not recognized. What I have to do?

Software/Hardware used:
the client program is developed in C and my AS400 is V5R3M0

Answer Wiki

Thanks. We'll let you know when a new response is added.

When I have run into this issue I’ve been using interface software used to create a list of tables (like MS Access or Eclipse) for the client application. In those cases, I’ve needed to delete the table from the list, open the interface to the ODBC driver, and then re-select updated the table(s) to refresh the metadata in the data dictionary. I don’t whether you use something like this, but it sounds to me like there is dictionary information being stored somewhere that needs to be replaced with the metadata for the new column format- unless it is defined directly in your client program (then it needs to be changed there). You might have already done this….sorry, I’m better at doing things than explaining them.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • TomLiotta
    I had to change the length of numeric field (3 to 8) but the client program not recognized. How can you tell that the client program doesn't recognize the change? Is there an error? If so, what is it? What do you see that indicates a problem? After you changed the DDS, did you recompile it? Did you use the CHGPF command? Is the change recognized on the AS/400 when you run a query on the server itself? Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    Stupid editor -- assumes that "8" followed by ")" is 8) ?...ah, well. Tom
    125,585 pointsBadges:
    report
  • Yorkshireman
    how i hate those 'clever' editors that take perfectly good ascii I type and mangle it. The whole point of a :- ) is that it is ascii art. (grumble grumble... )
    5,580 pointsBadges:
    report
  • Oldpgmritk
    Using this in ms access, when a table was changed, we had to go into Linked Table Manager & update the link.
    20 pointsBadges:
    report

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