Home > IT Answers > AS/400 > ODBC problem Changing Structure Table
pmalopez
5 pts.
 ODBC problem Changing Structure Table
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
ASKED: September 23, 2011  5:18 PM
UPDATED: March 31, 2012  1:16 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  September 28, 2011  7:08 pm  by  Marz   355 pts.
All Answer Wiki Contributors:  Marz   355 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

TomLiotta
 107,995 pts.
 

Stupid editor — assumes that “8″ followed by “)” is 8) ?…ah, well.

Tom

TomLiotta
 107,995 pts.
 

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

Yorkshireman
 5,505 pts.
 

Using this in ms access, when a table was changed, we had to go into Linked Table Manager & update the link.

Oldpgmritk
 20 pts.