View previous topic :: View next topic
|
Author |
Message |
Tim Jones
New User
Joined: 22 Jul 2011 Posts: 11 Location: USA
|
|
|
|
I am trying to load my test db2 table using ther following:
"ST02 EXEC DSNUPROC,SYSTEM=DSNT,UID='RANLOAD',UTPROC='' ' and keep getting a -532 error. Can anyone tell me how to resolue the error ?? It used to work, but now even out DBA can get it to work.
Thanks |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
Tim Jones wrote: |
I am trying to load my test db2 table using ther following:
"ST02 EXEC DSNUPROC,SYSTEM=DSNT,UID='RANLOAD',UTPROC='' ' and keep getting a -532 error. Can anyone tell me how to resolue the error ?? It used to work, but now even out DBA can get it to work.
Thanks |
As the fine manual will tell you, a -532 indicates that a DELETE statement failed because its cascade to descendant tables violated a constraint. The full message indicates the tables involved and the descendant row on which the error occurred. |
|
Back to top |
|
|
Tim Jones
New User
Joined: 22 Jul 2011 Posts: 11 Location: USA
|
|
|
|
I have finally loaded my RAN DB2 table. There is a view on this table. Does the view get generated when you load the table, or do I have to build the view after the table has been loaded ??
Thanks |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
Tim Jones wrote: |
I have finally loaded my RAN DB2 table. There is a view on this table. Does the view get generated when you load the table, or do I have to build the view after the table has been loaded ??
Thanks |
The view per se needs to be created (with, of course, a CREATE VIEW statement). However, the data will appear when the underlying table(s) are loaded. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
The view per se needs to be created (with, of course, a CREATE VIEW statement). |
This needs to be done only once and it sounds as though the view has already been CREATEd. (Re-)loading the table will not cause the view to be "lost". |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
dick scherrer wrote: |
Hello,
Quote: |
The view per se needs to be created (with, of course, a CREATE VIEW statement). |
This needs to be done only once and it sounds as though the view has already been CREATEd. (Re-)loading the table will not cause the view to be "lost". |
True; I should have written more clearly. |
|
Back to top |
|
|
Tim Jones
New User
Joined: 22 Jul 2011 Posts: 11 Location: USA
|
|
|
|
Thanks to ALL. I have been able to re-load the test system with production data. I can now finish my testing. We need a good DBA here. The only DBA we have is going to retire next year, so he isn't too eager to learn things that he should know.
Thanks again to ALL |
|
Back to top |
|
|
|