Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table Editor

Status
Not open for further replies.
juergenkemeter

juergenkemeter

Programmer
Joined
Oct 6, 2004
Messages
27
Location
NZ
Hi,
I have several forms which are connected with Buttons.
The Insert on the Main Form works without problems.
When I wan to Insert on other Forms, I get a Failure Notice:

"An error occurred whils running the SQL statement. Duplicate column name XXX in INSERT or UPDATE"

I can send you my forms via Email if it helps.

Thanks for your help,
Jürgen Kemeter
 
Sort by date Sort by votes
Jurgen,
Are you able to look behind the forms in order to see what SQL is being run? If so, are you able to alter or amend this in any way? It seems possible that the SQL that is being generated has a column defined twice in the update statement.
Marc
 
Upvote 0 Downvote
Hi,
sorry I can's look into the SQL code which is produced.
Do you have Table Editor yourself? Then I can send you the forms if it helps...

Jürgen
 
Upvote 0 Downvote
Jurgen,
The only 'Table Editor' I have is under QMF, and I'm fairly certain that is not what you mean, as you probably mean this:
Don't think I can help much more and would suggest asking around your site to see if anybody has the required knowledge.

Marc
 
Upvote 0 Downvote
Hi,
I have run a trace function. You can see the result in addition to my text. But nevertheless I don't understand so much about this that I would be able to find the failure.

Ciao
Jürgen


===== TRACE ================= 00000600/0000041C == Wed Oct 27 15:31:04.18 2004
Trace started
Trace DLL version = 107.1.0.12

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.54 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0002')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.54 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'013FC980')
----------------------- Buffer at address x'013FC980' ------------------------
0000 0000001B E2C5D3C5 C3E3405C 40C6D9D6 >..........@\@...< >....SELECT * FRO<
0010 D440C8C9 D3C6E2E2 E3D64BD9 C5E2E4 >.@........K.... < >M HILFSSTO.RESU <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.55 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'0135A118')
----------------------- Buffer at address x'0135A118' ------------------------
0000 FF000B00 00000000 00000000 00000401 >................< >................<
0010 F0000000 000006D9 C5E2E4C9 C4000000 >................< >0......RESUID...<
0020 06D9C5E2 E4C9C400 000000FF 00000000 >................< >.RESUID.........<
0030 00000000 0000012C 01C90111 00000008 >.......,........< >.........I......<
0040 D9C5E2E4 D5C1D4C5 00000008 D9C5E2E4 >................< >RESUNAME....RESU<
0050 D5C1D4C5 00000000 FF000000 00000000 >................< >NAME............<
0060 00000001 2C01C901 11000000 07D9C5C9 >....,...........< >......I......REI<
0070 E4D7C1C3 00000007 D9C5C9E4 D7C1C300 >................< >UPAC....REIUPAC.<
0080 000000FF 00000000 00000000 0000012C >...............,< >................<
0090 01C90111 00000007 D9C5C3C1 E2D5D900 >................< >.I......RECASNR.<
00A0 000007D9 C5C3C1E2 D5D90000 0000FF00 >................< >...RECASNR......<
00B0 00000000 00000000 00012C01 C9011100 >..........,.....< >............I...<
00C0 000006D9 C5C9C4D5 D9000000 06D9C5C9 >................< >...REIDNR....REI<
00D0 C4D5D900 000000FF 00040002 00000000 >................< >DNR.............<
00E0 00000402 01E50000 00000008 D9C5D4D6 >................< >.....V......REMO<
00F0 D3C7C5E6 00000008 D9C5D4D6 D3C7C5E6 >................< >LGEW....REMOLGEW<
0100 00000000 FF000000 00000000 00000001 >................< >................<
0110 2C01C901 11000000 06D9C5E2 E4C6D600 >,...............< >..I......RESUFO.<
0120 000006D9 C5E2E4C6 D6000000 00FF0000 >................< >...RESUFO.......<
0130 00000000 00000000 012C01C9 01110000 >.........,......< >...........I....<
0140 0007D9C5 E2E3D9C6 D6000000 07D9C5E2 >................< >..RESTRFO....RES<
0150 E3D9C6D6 00000000 FF000000 00000000 >................< >TRFO............<
0160 00000001 2C01C901 11000000 06D9C5D4 >....,...........< >......I......REM<
0170 E2C4E200 000006D9 C5D4E2C4 E2000000 >................< >SDS....REMSDS...<
0180 00FF0000 00000000 00000000 012C01C9 >.............,..< >...............I<
0190 01110000 0008D9C5 C7C5C6C8 C9D50000 >................< >......REGEFHIN..<
01A0 0008D9C5 C7C5C6C8 C9D50000 0000FF00 >................< >..REGEFHIN......<
01B0 00000000 00000000 000BB801 C9011100 >................< >............I...<
01C0 000005D9 C5E2E8D5 00000005 D9C5E2E8 >................< >...RESYN....RESY<
01D0 D5000000 00FF >...... < >N..... <
------------------------------------------------------------------------------

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:09.57 2004
Receiving SQLDARD

SQLCA
SQL Code = 0
SQL State = 00000
Error procedure: <>
RDB name = <>
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

SQLDA
Label = , Name = RESUID, Type = 496, Length = 4, Precision = 0, Scale = 0, CCSID = 0, UDTName = ---- INTEGER NOT NULL
Label = , Name = RESUNAME, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REIUPAC, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RECASNR, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REIDNR, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REMOLGEW, Type = 485, Length = 1026, Precision = 4, Scale = 2, CCSID = 0, UDTName = ---- DECIMAL(4 , 2)
Label = , Name = RESUFO, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RESTRFO, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REMSDS, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REGEFHIN, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RESYN, Type = 457, Length = 3000, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.63 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0003')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.63 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'01362C58')
----------------------- Buffer at address x'01362C58' ------------------------
0000 0000001B E2C5D3C5 C3E3405C 40C6D9D6 >..........@\@...< >....SELECT * FRO<
0010 D440C8C9 D3C6E2E2 E3D64BD9 C5E2E4 >.@........K.... < >M HILFSSTO.RESU <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.64 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'0135A118')
----------------------- Buffer at address x'0135A118' ------------------------
0000 FF000B00 00000000 00000000 00000401 >................< >................<
0010 F0000000 000006D9 C5E2E4C9 C4000000 >................< >0......RESUID...<
0020 06D9C5E2 E4C9C400 000000FF 00000000 >................< >.RESUID.........<
0030 00000000 0000012C 01C90111 00000008 >.......,........< >.........I......<
0040 D9C5E2E4 D5C1D4C5 00000008 D9C5E2E4 >................< >RESUNAME....RESU<
0050 D5C1D4C5 00000000 FF000000 00000000 >................< >NAME............<
0060 00000001 2C01C901 11000000 07D9C5C9 >....,...........< >......I......REI<
0070 E4D7C1C3 00000007 D9C5C9E4 D7C1C300 >................< >UPAC....REIUPAC.<
0080 000000FF 00000000 00000000 0000012C >...............,< >................<
0090 01C90111 00000007 D9C5C3C1 E2D5D900 >................< >.I......RECASNR.<
00A0 000007D9 C5C3C1E2 D5D90000 0000FF00 >................< >...RECASNR......<
00B0 00000000 00000000 00012C01 C9011100 >..........,.....< >............I...<
00C0 000006D9 C5C9C4D5 D9000000 06D9C5C9 >................< >...REIDNR....REI<
00D0 C4D5D900 000000FF 00040002 00000000 >................< >DNR.............<
00E0 00000402 01E50000 00000008 D9C5D4D6 >................< >.....V......REMO<
00F0 D3C7C5E6 00000008 D9C5D4D6 D3C7C5E6 >................< >LGEW....REMOLGEW<
0100 00000000 FF000000 00000000 00000001 >................< >................<
0110 2C01C901 11000000 06D9C5E2 E4C6D600 >,...............< >..I......RESUFO.<
0120 000006D9 C5E2E4C6 D6000000 00FF0000 >................< >...RESUFO.......<
0130 00000000 00000000 012C01C9 01110000 >.........,......< >...........I....<
0140 0007D9C5 E2E3D9C6 D6000000 07D9C5E2 >................< >..RESTRFO....RES<
0150 E3D9C6D6 00000000 FF000000 00000000 >................< >TRFO............<
0160 00000001 2C01C901 11000000 06D9C5D4 >....,...........< >......I......REM<
0170 E2C4E200 000006D9 C5D4E2C4 E2000000 >................< >SDS....REMSDS...<
0180 00FF0000 00000000 00000000 012C01C9 >.............,..< >...............I<
0190 01110000 0008D9C5 C7C5C6C8 C9D50000 >................< >......REGEFHIN..<
01A0 0008D9C5 C7C5C6C8 C9D50000 0000FF00 >................< >..REGEFHIN......<
01B0 00000000 00000000 000BB801 C9011100 >................< >............I...<
01C0 000005D9 C5E2E8D5 00000005 D9C5E2E8 >................< >...RESYN....RESY<
01D0 D5000000 00FF >...... < >N..... <
------------------------------------------------------------------------------

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:09.65 2004
Receiving SQLDARD

SQLCA
SQL Code = 0
SQL State = 00000
Error procedure: <>
RDB name = <>
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

SQLDA
Label = , Name = RESUID, Type = 496, Length = 4, Precision = 0, Scale = 0, CCSID = 0, UDTName = ---- INTEGER NOT NULL
Label = , Name = RESUNAME, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REIUPAC, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RECASNR, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REIDNR, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REMOLGEW, Type = 485, Length = 1026, Precision = 4, Scale = 2, CCSID = 0, UDTName = ---- DECIMAL(4 , 2)
Label = , Name = RESUFO, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RESTRFO, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REMSDS, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REGEFHIN, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RESYN, Type = 457, Length = 3000, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.74 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0004')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.74 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'01373B60')
----------------------- Buffer at address x'01373B60' ------------------------
0000 0000003B E2C5D3C5 C3E340D9 C5D9C5E2 >...;......@.....< >....SELECT RERES<
0010 C3E4C540 C6D9D6D4 40C8C9D3 C6E2E2E3 >...@....@.......< >CUE FROM HILFSST<
0020 D64BD9C5 D9C5E2C3 E4C540E6 C8C5D9C5 >.K........@.....< >O.RERESCUE WHERE<
0030 40D9C5E2 E4C9C440 C9E240D5 E4D3D3 >@......@..@.... < > RESUID IS NULL <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.75 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'01373440')
----------------------- Buffer at address x'01373440' ------------------------
0000 FF000100 00000000 00000000 00012C01 >..............,.< >................<
0010 C9011100 000008D9 C5D9C5E2 C3E4C500 >................< >I......RERESCUE.<
0020 000008D9 C5D9C5E2 C3E4C500 000000FF >................< >...RERESCUE.....<
------------------------------------------------------------------------------

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:09.75 2004
Receiving SQLDARD

SQLCA
SQL Code = 0
SQL State = 00000
Error procedure: <>
RDB name = <>
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

SQLDA
Label = , Name = RERESCUE, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.79 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0005')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.79 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'013B9BB8')
----------------------- Buffer at address x'013B9BB8' ------------------------
0000 0000003B E2C5D3C5 C3E340D9 C5E2C1C6 >...;......@.....< >....SELECT RESAF<
0010 C5E3E840 C6D9D6D4 40C8C9D3 C6E2E2E3 >...@....@.......< >ETY FROM HILFSST<
0020 D64BD9C5 E2C1C6C5 E3E840E6 C8C5D9C5 >.K........@.....< >O.RESAFETY WHERE<
0030 40D9C5E2 E4C9C440 C9E240D5 E4D3D3 >@......@..@.... < > RESUID IS NULL <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.80 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'013FCCF0')
----------------------- Buffer at address x'013FCCF0' ------------------------
0000 FF000100 00000000 00000000 00012C01 >..............,.< >................<
0010 C9011100 000008D9 C5E2C1C6 C5E3E800 >................< >I......RESAFETY.<
0020 000008D9 C5E2C1C6 C5E3E800 000000FF >................< >...RESAFETY.....<
------------------------------------------------------------------------------

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:09.81 2004
Receiving SQLDARD

SQLCA
SQL Code = 0
SQL State = 00000
Error procedure: <>
RDB name = <>
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

SQLDA
Label = , Name = RESAFETY, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.84 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0006')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.85 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'013B8210')
----------------------- Buffer at address x'013B8210' ------------------------
0000 00000037 E2C5D3C5 C3E340D9 C5D7C9C3 >...7......@.....< >....SELECT REPIC<
0010 E340C6D9 D6D440C8 C9D3C6E2 E2E3D64B >.@....@........K< >T FROM HILFSSTO.<
0020 D9C5D7C9 C3E340E6 C8C5D9C5 40D9C5E2 >......@.....@...< >REPICT WHERE RES<
0030 E4C9C440 C9E240D5 E4D3D3 >...@..@.... < >UID IS NULL <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.85 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'013FCC08')
----------------------- Buffer at address x'013FCC08' ------------------------
0000 FF000100 00000000 00000000 00012C01 >..............,.< >................<
0010 C9011100 000006D9 C5D7C9C3 E3000000 >................< >I......REPICT...<
0020 06D9C5D7 C9C3E300 000000FF >............ < >.REPICT..... <
------------------------------------------------------------------------------

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:09.86 2004
Receiving SQLDARD

SQLCA
SQL Code = 0
SQL State = 00000
Error procedure: <>
RDB name = <>
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

SQLDA
Label = , Name = REPICT, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.89 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0004')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.90 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'01378CD8')
----------------------- Buffer at address x'01378CD8' ------------------------
0000 0000003B E2C5D3C5 C3E340D9 C5D9C5E2 >...;......@.....< >....SELECT RERES<
0010 C3E4C540 C6D9D6D4 40C8C9D3 C6E2E2E3 >...@....@.......< >CUE FROM HILFSST<
0020 D64BD9C5 D9C5E2C3 E4C540E6 C8C5D9C5 >.K........@.....< >O.RERESCUE WHERE<
0030 40D9C5E2 E4C9C440 C9E240D5 E4D3D3 >@......@..@.... < > RESUID IS NULL <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.90 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'013FCCF0')
----------------------- Buffer at address x'013FCCF0' ------------------------
0000 FF000100 00000000 00000000 00012C01 >..............,.< >................<
0010 C9011100 000008D9 C5D9C5E2 C3E4C500 >................< >I......RERESCUE.<
0020 000008D9 C5D9C5E2 C3E4C500 000000FF >................< >...RERESCUE.....<
------------------------------------------------------------------------------

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:09.91 2004
Receiving SQLDARD

SQLCA
SQL Code = 0
SQL State = 00000
Error procedure: <>
RDB name = <>
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

SQLDA
Label = , Name = RERESCUE, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.94 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0005')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.95 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'013A9F78')
----------------------- Buffer at address x'013A9F78' ------------------------
0000 0000003B E2C5D3C5 C3E340D9 C5E2C1C6 >...;......@.....< >....SELECT RESAF<
0010 C5E3E840 C6D9D6D4 40C8C9D3 C6E2E2E3 >...@....@.......< >ETY FROM HILFSST<
0020 D64BD9C5 E2C1C6C5 E3E840E6 C8C5D9C5 >.K........@.....< >O.RESAFETY WHERE<
0030 40D9C5E2 E4C9C440 C9E240D5 E4D3D3 >@......@..@.... < > RESUID IS NULL <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.95 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'013FCC08')
----------------------- Buffer at address x'013FCC08' ------------------------
0000 FF000100 00000000 00000000 00012C01 >..............,.< >................<
0010 C9011100 000008D9 C5E2C1C6 C5E3E800 >................< >I......RESAFETY.<
0020 000008D9 C5E2C1C6 C5E3E800 000000FF >................< >...RESAFETY.....<
------------------------------------------------------------------------------

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:09.96 2004
Receiving SQLDARD

SQLCA
SQL Code = 0
SQL State = 00000
Error procedure: <>
RDB name = <>
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

SQLDA
Label = , Name = RESAFETY, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.99 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0006')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:09.99 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'013A9F78')
----------------------- Buffer at address x'013A9F78' ------------------------
0000 00000037 E2C5D3C5 C3E340D9 C5D7C9C3 >...7......@.....< >....SELECT REPIC<
0010 E340C6D9 D6D440C8 C9D3C6E2 E2E3D64B >.@....@........K< >T FROM HILFSSTO.<
0020 D9C5D7C9 C3E340E6 C8C5D9C5 40D9C5E2 >......@.....@...< >REPICT WHERE RES<
0030 E4C9C440 C9E240D5 E4D3D3 >...@..@.... < >UID IS NULL <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.00 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'013FCCF0')
----------------------- Buffer at address x'013FCCF0' ------------------------
0000 FF000100 00000000 00000000 00012C01 >..............,.< >................<
0010 C9011100 000006D9 C5D7C9C3 E3000000 >................< >I......REPICT...<
0020 06D9C5D7 C9C3E300 000000FF >............ < >.REPICT..... <
------------------------------------------------------------------------------

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:10.01 2004
Receiving SQLDARD

SQLCA
SQL Code = 0
SQL State = 00000
Error procedure: <>
RDB name = <>
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

SQLDA
Label = , Name = REPICT, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.10 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0004')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.11 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'01370438')
----------------------- Buffer at address x'01370438' ------------------------
0000 0000003B E2C5D3C5 C3E340D9 C5D9C5E2 >...;......@.....< >....SELECT RERES<
0010 C3E4C540 C6D9D6D4 40C8C9D3 C6E2E2E3 >...@....@.......< >CUE FROM HILFSST<
0020 D64BD9C5 D9C5E2C3 E4C540E6 C8C5D9C5 >.K........@.....< >O.RERESCUE WHERE<
0030 40D9C5E2 E4C9C440 C9E240D5 E4D3D3 >@......@..@.... < > RESUID IS NULL <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.11 2004
Sending

RQSDSS
Correlator = x'0002'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

OPNQRY(
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0004')),
QRYBLKSZ(x'00007FFF'),
OUTOVROPT(x'01'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.12 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'013FCCF0')
----------------------- Buffer at address x'013FCCF0' ------------------------
0000 FF000100 00000000 00000000 00012C01 >..............,.< >................<
0010 C9011100 000008D9 C5D9C5E2 C3E4C500 >................< >I......RERESCUE.<
0020 000008D9 C5D9C5E2 C3E4C500 000000FF >................< >...RERESCUE.....<
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.25 2004
Received

RPYDSS
Correlator = x'0002'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

OPNQRYRM(
SVRCOD(x'0000'),
QRYPRCTYP(x'2417'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.25 2004
Received

OBJDSS
Correlator = x'0002'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

QRYDSC(Data at x'013B8F90'),
QRYDTA(Data at x'013A9AD8')
----------------------- Buffer at address x'013B8F90' ------------------------
0000 0676D035 012C0971 E0540001 D0000106 >.v.5.,.q.T......< >..}.....\...}...<
0010 71F0E000 00 >q.... < >.0\.. <
------------------------------------------------------------------------------
----------------------- Buffer at address x'013A9AD8' ------------------------
0000 FF000000 49C4A499 838840E2 83889381 >....I.....@.....< >.....Durch Schla<
0010 876B40D9 858982A4 95876B40 C685A485 >.k@.......k@....< >g, Reibung, Feue<
0020 99409684 85994081 95848599 8540E9D0 >.@....@......@..< >r oder andere Z}<
0030 958498A4 85939385 954085A7 979396A2 >.........@......< >ndquellen explos<
0040 899695A2 878586C0 88999389 8388FF00 >................< >ionsgef{hrlich..<
0050 000016D2 81959540 C2998195 8440A585 >.......@.....@..< >...Kann Brand ve<
0060 99A499A2 81838885 95 >......... < >rursachen <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.26 2004
Received

RPYDSS
Correlator = x'0002'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

ENDQRYRM(
SVRCOD(x'0004'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.26 2004
Received

OBJDSS
Correlator = x'0002'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLCARD(Data at x'013B80A0')
----------------------- Buffer at address x'013B80A0' ------------------------
0000 00000000 64F0F2F0 F0F0D8E2 D8C6C5E3 >....d...........< >.....02000QSQFET<
0010 C3C800D7 D3C1D5E3 C1C1E240 40404040 >...........@@@@@< >CH.PLANTAAS <
0020 40404040 40000000 00000000 00000000 >@@@@@...........< > ...........<
0030 00000000 00000000 00000000 00404040 >.............@@@< >............. <
0040 40404040 40404040 00000009 0007C3E4 >@@@@@@@@........< > ......CU<
0050 D9E2D6D9 F4 >..... < >RSOR4 <
------------------------------------------------------------------------------

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:10.27 2004
Receiving SQLDARD

SQLCA
SQL Code = 0
SQL State = 00000
Error procedure: <>
RDB name = <>
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

SQLDA
Label = , Name = RERESCUE, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:10.27 2004
Receiving Result Set column definitions

Result Set column definitions
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:10.27 2004
Receiving SQLCA

SQLCA
SQL Code = 100
SQL State = 02000
Error procedure: <QSQFETCH>
RDB name = <PLANTAAS >
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.31 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0005')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.31 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'013FB048')
----------------------- Buffer at address x'013FB048' ------------------------
0000 0000003B E2C5D3C5 C3E340D9 C5E2C1C6 >...;......@.....< >....SELECT RESAF<
0010 C5E3E840 C6D9D6D4 40C8C9D3 C6E2E2E3 >...@....@.......< >ETY FROM HILFSST<
0020 D64BD9C5 E2C1C6C5 E3E840E6 C8C5D9C5 >.K........@.....< >O.RESAFETY WHERE<
0030 40D9C5E2 E4C9C440 C9E240D5 E4D3D3 >@......@..@.... < > RESUID IS NULL <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.32 2004
Sending

RQSDSS
Correlator = x'0002'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

OPNQRY(
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0005')),
QRYBLKSZ(x'00007FFF'),
OUTOVROPT(x'01'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.32 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'013CCD58')
----------------------- Buffer at address x'013CCD58' ------------------------
0000 FF000100 00000000 00000000 00012C01 >..............,.< >................<
0010 C9011100 000008D9 C5E2C1C6 C5E3E800 >................< >I......RESAFETY.<
0020 000008D9 C5E2C1C6 C5E3E800 000000FF >................< >...RESAFETY.....<
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.45 2004
Received

RPYDSS
Correlator = x'0002'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

OPNQRYRM(
SVRCOD(x'0000'),
QRYPRCTYP(x'2417'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.45 2004
Received

OBJDSS
Correlator = x'0002'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

QRYDSC(Data at x'013D2050')
----------------------- Buffer at address x'013D2050' ------------------------
0000 0676D035 012C0971 E0540001 D0000106 >.v.5.,.q.T......< >..}.....\...}...<
0010 71F0E000 00 >q.... < >.0\.. <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.45 2004
Received

RPYDSS
Correlator = x'0002'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

ENDQRYRM(
SVRCOD(x'0004'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.46 2004
Received

OBJDSS
Correlator = x'0002'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLCARD(Data at x'013C1558')
----------------------- Buffer at address x'013C1558' ------------------------
0000 00000000 64F0F2F0 F0F0D8E2 D8C6C5E3 >....d...........< >.....02000QSQFET<
0010 C3C800D7 D3C1D5E3 C1C1E240 40404040 >...........@@@@@< >CH.PLANTAAS <
0020 40404040 40000000 00000000 00000000 >@@@@@...........< > ...........<
0030 00000000 00000000 00000000 00404040 >.............@@@< >............. <
0040 40404040 40404040 00000009 0007C3E4 >@@@@@@@@........< > ......CU<
0050 D9E2D6D9 F5 >..... < >RSOR5 <
------------------------------------------------------------------------------

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:10.46 2004
Receiving SQLDARD

SQLCA
SQL Code = 0
SQL State = 00000
Error procedure: <>
RDB name = <>
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

SQLDA
Label = , Name = RESAFETY, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:10.47 2004
Receiving Result Set column definitions

Result Set column definitions
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:10.48 2004
Receiving SQLCA

SQLCA
SQL Code = 100
SQL State = 02000
Error procedure: <QSQFETCH>
RDB name = <PLANTAAS >
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.51 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0006')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.52 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'013AE188')
----------------------- Buffer at address x'013AE188' ------------------------
0000 00000037 E2C5D3C5 C3E340D9 C5D7C9C3 >...7......@.....< >....SELECT REPIC<
0010 E340C6D9 D6D440C8 C9D3C6E2 E2E3D64B >.@....@........K< >T FROM HILFSSTO.<
0020 D9C5D7C9 C3E340E6 C8C5D9C5 40D9C5E2 >......@.....@...< >REPICT WHERE RES<
0030 E4C9C440 C9E240D5 E4D3D3 >...@..@.... < >UID IS NULL <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.52 2004
Sending

RQSDSS
Correlator = x'0002'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

OPNQRY(
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0006')),
QRYBLKSZ(x'00007FFF'),
OUTOVROPT(x'01'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.53 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'013FCCF0')
----------------------- Buffer at address x'013FCCF0' ------------------------
0000 FF000100 00000000 00000000 00012C01 >..............,.< >................<
0010 C9011100 000006D9 C5D7C9C3 E3000000 >................< >I......REPICT...<
0020 06D9C5D7 C9C3E300 000000FF >............ < >.REPICT..... <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.65 2004
Received

RPYDSS
Correlator = x'0002'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

OPNQRYRM(
SVRCOD(x'0000'),
QRYPRCTYP(x'2417'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.65 2004
Received

OBJDSS
Correlator = x'0002'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

QRYDSC(Data at x'01375EB8')
----------------------- Buffer at address x'01375EB8' ------------------------
0000 0676D035 012C0971 E0540001 D0000106 >.v.5.,.q.T......< >..}.....\...}...<
0010 71F0E000 00 >q.... < >.0\.. <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.65 2004
Received

RPYDSS
Correlator = x'0002'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

ENDQRYRM(
SVRCOD(x'0004'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:10.66 2004
Received

OBJDSS
Correlator = x'0002'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

SQLCARD(Data at x'01394D70')
----------------------- Buffer at address x'01394D70' ------------------------
0000 00000000 64F0F2F0 F0F0D8E2 D8C6C5E3 >....d...........< >.....02000QSQFET<
0010 C3C800D7 D3C1D5E3 C1C1E240 40404040 >...........@@@@@< >CH.PLANTAAS <
0020 40404040 40000000 00000000 00000000 >@@@@@...........< > ...........<
0030 00000000 00000000 00000000 00404040 >.............@@@< >............. <
0040 40404040 40404040 00000009 0007C3E4 >@@@@@@@@........< > ......CU<
0050 D9E2D6D9 F6 >..... < >RSOR6 <
------------------------------------------------------------------------------

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:10.66 2004
Receiving SQLDARD

SQLCA
SQL Code = 0
SQL State = 00000
Error procedure: <>
RDB name = <>
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

SQLDA
Label = , Name = REPICT, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:10.67 2004
Receiving Result Set column definitions

Result Set column definitions
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:10.67 2004
Receiving SQLCA

SQLCA
SQL Code = 100
SQL State = 02000
Error procedure: <QSQFETCH>
RDB name = <PLANTAAS >
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0000, ErrD5 = 0000, ErrD6 = 0000
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.15 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0066')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.16 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'013DCBD0')
----------------------- Buffer at address x'013DCBD0' ------------------------
0000 000000C4 E2C5D3C5 C3E340D9 C5C7C5C6 >..........@.....< >...DSELECT REGEF<
0010 C8C9D56B D9C5D4E2 C4E26BD9 C5C9E4D7 >...k......k.....< >HIN,REMSDS,REIUP<
0020 C1C36BD9 C5E2E3D9 C6D66BD9 C5D4D6D3 >..k.......k.....< >AC,RESTRFO,REMOL<
0030 C7C5E66B D9C5E2E4 C6D66BD9 C5C3C1E2 >...k......k.....< >GEW,RESUFO,RECAS<
0040 D5D96BD9 C5E2E8D5 6BD9C5E2 E4D5C1D4 >..k.....k.......< >NR,RESYN,RESUNAM<
0050 C56BD9C5 C9C4D5D9 6BD9C5E2 E4C9C46B >.k......k......k< >E,REIDNR,RESUID,<
0060 D9C5C7C5 C6C8C9D5 6BD9C5D4 E2C4E26B >........k......k< >REGEFHIN,REMSDS,<
0070 D9C5C9E4 D7C1C36B D9C5E2E3 D9C6D66B >.......k.......k< >REIUPAC,RESTRFO,<
0080 D9C5D4D6 D3C7C5E6 6BD9C5E2 E4C6D66B >........k......k< >REMOLGEW,RESUFO,<
0090 D9C5C3C1 E2D5D96B D9C5E2E8 D56BD9C5 >.......k.....k..< >RECASNR,RESYN,RE<
00A0 E2E4D5C1 D4C56BD9 C5C9C4D5 D96BD9C5 >......k......k..< >SUNAME,REIDNR,RE<
00B0 E2E4C9C4 40C6D9D6 D440C8C9 D3C6E2E2 >....@....@......< >SUID FROM HILFSS<
00C0 E3D64BD9 C5E2E440 >..K....@ < >TO.RESU <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.16 2004
Sending

RQSDSS
Correlator = x'0002'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

OPNQRY(
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0066')),
QRYBLKSZ(x'00007FFF'),
QRYBLKCTL(x'2410'),
OUTOVROPT(x'01'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.19 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'013DBBB8')
----------------------- Buffer at address x'013DBBB8' ------------------------
0000 00000000 00F0F0F0 F0F0D8E2 D8D9D6E4 >................< >.....00000QSQROU<
0010 E3C100D7 D3C1D5E3 C1C1E240 40404040 >...........@@@@@< >TA.PLANTAAS <
0020 40404040 40000000 00000000 00000000 >@@@@@...........< > ...........<
0030 00000000 01000000 00F7F9F6 F7404040 >.............@@@< >.........7967 <
0040 40404040 40404040 00000000 00160000 >@@@@@@@@........< > ........<
0050 00000000 00000000 012C01C9 01110000 >.........,......< >...........I....<
0060 0008D9C5 C7C5C6C8 C9D50000 0008D9C5 >................< >..REGEFHIN....RE<
0070 C7C5C6C8 C9D50000 0000FF00 00000000 >................< >GEFHIN..........<
0080 00000000 00012C01 C9011100 000006D9 >......,.........< >........I......R<
0090 C5D4E2C4 E2000000 06D9C5D4 E2C4E200 >................< >EMSDS....REMSDS.<
00A0 000000FF 00000000 00000000 0000012C >...............,< >................<
00B0 01C90111 00000007 D9C5C9E4 D7C1C300 >................< >.I......REIUPAC.<
00C0 000007D9 C5C9E4D7 C1C30000 0000FF00 >................< >...REIUPAC......<
00D0 00000000 00000000 00012C01 C9011100 >..........,.....< >............I...<
00E0 000007D9 C5E2E3D9 C6D60000 0007D9C5 >................< >...RESTRFO....RE<
00F0 E2E3D9C6 D6000000 00FF0004 00020000 >................< >STRFO...........<
0100 00000000 040201E5 00000000 0008D9C5 >................< >.......V......RE<
0110 D4D6D3C7 C5E60000 0008D9C5 D4D6D3C7 >................< >MOLGEW....REMOLG<
0120 C5E60000 0000FF00 00000000 00000000 >................< >EW..............<
0130 00012C01 C9011100 000006D9 C5E2E4C6 >..,.............< >....I......RESUF<
0140 D6000000 06D9C5E2 E4C6D600 000000FF >................< >O....RESUFO.....<
0150 00000000 00000000 0000012C 01C90111 >...........,....< >.............I..<
0160 00000007 D9C5C3C1 E2D5D900 000007D9 >................< >....RECASNR....R<
0170 C5C3C1E2 D5D90000 0000FF00 00000000 >................< >ECASNR..........<
0180 00000000 000BB801 C9011100 000005D9 >................< >........I......R<
0190 C5E2E8D5 00000005 D9C5E2E8 D5000000 >................< >ESYN....RESYN...<
01A0 00FF0000 00000000 00000000 012C01C9 >.............,..< >...............I<
01B0 01110000 0008D9C5 E2E4D5C1 D4C50000 >................< >......RESUNAME..<
01C0 0008D9C5 E2E4D5C1 D4C50000 0000FF00 >................< >..RESUNAME......<
01D0 00000000 00000000 00012C01 C9011100 >..........,.....< >............I...<
01E0 000006D9 C5C9C4D5 D9000000 06D9C5C9 >................< >...REIDNR....REI<
01F0 C4D5D900 000000FF 00000000 00000000 >................< >DNR.............<
0200 00000004 01F00000 00000006 D9C5E2E4 >................< >.....0......RESU<
0210 C9C40000 0006D9C5 E2E4C9C4 00000000 >................< >ID....RESUID....<
0220 FF000000 00000000 00000001 2C01C901 >............,...< >..............I.<
0230 11000000 08D9C5C7 C5C6C8C9 D5000000 >................< >.....REGEFHIN...<
0240 08D9C5C7 C5C6C8C9 D5000000 00FF0000 >................< >.REGEFHIN.......<
0250 00000000 00000000 012C01C9 01110000 >.........,......< >...........I....<
0260 0006D9C5 D4E2C4E2 00000006 D9C5D4E2 >................< >..REMSDS....REMS<
0270 C4E20000 0000FF00 00000000 00000000 >................< >DS..............<
0280 00012C01 C9011100 000007D9 C5C9E4D7 >..,.............< >....I......REIUP<
0290 C1C30000 0007D9C5 C9E4D7C1 C3000000 >................< >AC....REIUPAC...<
02A0 00FF0000 00000000 00000000 012C01C9 >.............,..< >...............I<
02B0 01110000 0007D9C5 E2E3D9C6 D6000000 >................< >......RESTRFO...<
02C0 07D9C5E2 E3D9C6D6 00000000 FF000400 >................< >.RESTRFO........<
02D0 02000000 00000004 0201E500 00000000 >................< >..........V.....<
02E0 08D9C5D4 D6D3C7C5 E6000000 08D9C5D4 >................< >.REMOLGEW....REM<
02F0 D6D3C7C5 E6000000 00FF0000 00000000 >................< >OLGEW...........<
0300 00000000 012C01C9 01110000 0006D9C5 >.....,..........< >.......I......RE<
0310 E2E4C6D6 00000006 D9C5E2E4 C6D60000 >................< >SUFO....RESUFO..<
0320 0000FF00 00000000 00000000 00012C01 >..............,.< >................<
0330 C9011100 000007D9 C5C3C1E2 D5D90000 >................< >I......RECASNR..<
0340 0007D9C5 C3C1E2D5 D9000000 00FF0000 >................< >..RECASNR.......<
0350 00000000 00000000 0BB801C9 01110000 >................< >...........I....<
0360 0005D9C5 E2E8D500 000005D9 C5E2E8D5 >................< >..RESYN....RESYN<
0370 00000000 FF000000 00000000 00000001 >................< >................<
0380 2C01C901 11000000 08D9C5E2 E4D5C1D4 >,...............< >..I......RESUNAM<
0390 C5000000 08D9C5E2 E4D5C1D4 C5000000 >................< >E....RESUNAME...<
03A0 00FF0000 00000000 00000000 012C01C9 >.............,..< >...............I<
03B0 01110000 0006D9C5 C9C4D5D9 00000006 >................< >......REIDNR....<
03C0 D9C5C9C4 D5D90000 0000FF00 00000000 >................< >REIDNR..........<
03D0 00000000 00000401 F0000000 000006D9 >................< >........0......R<
03E0 C5E2E4C9 C4000000 06D9C5E2 E4C9C400 >................< >ESUID....RESUID.<
03F0 000000FF >.... < >.... <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.35 2004
Received

RPYDSS
Correlator = x'0002'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

OPNQRYRM(
SVRCOD(x'0000'),
QRYPRCTYP(x'2418'),
SQLCSRHLD(True))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.35 2004
Received

OBJDSS
Correlator = x'0002'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

QRYDSC(Data at x'01376B68')
----------------------- Buffer at address x'01376B68' ------------------------
0000 4576D035 012C3501 2C35012C 35012C0F >Ev.5.,5.,5.,5.,.< >..}.............<
0010 04023501 2C35012C 350BB835 012C3501 >..5.,5.,5..5.,5.< >................<
0020 2C020004 35012C35 012C3501 2C35012C >,...5.,5.,5.,5.,< >................<
0030 0F040235 012C3501 2C350BB8 35012C35 >...5.,5.,5..5.,5< >................<
0040 012C0200 040971E0 540001D0 00010671 >.,....q.T......q< >.......\...}....<
0050 F0E00000 >.... < >0\.. <
------------------------------------------------------------------------------

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:11.36 2004
Receiving SQLDARD

SQLCA
SQL Code = 0
SQL State = 00000
Error procedure: <QSQROUTA>
RDB name = <PLANTAAS >
ErrD1 = 0000, ErrD2 = 0000, ErrD3 = 0000, ErrD4 = 0001, ErrD5 = 0000, ErrD6 = -134613257
Warn1 = , Warn2 = , Warn3 = , Warn4 = , Warn5 =
Warn6 = , Warn7 = , Warn8 = , Warn9 = , WarnA =
Error message: <>

SQLDA
Label = , Name = REGEFHIN, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REMSDS, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REIUPAC, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RESTRFO, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REMOLGEW, Type = 485, Length = 1026, Precision = 4, Scale = 2, CCSID = 0, UDTName = ---- DECIMAL(4 , 2)
Label = , Name = RESUFO, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RECASNR, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RESYN, Type = 457, Length = 3000, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RESUNAME, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REIDNR, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RESUID, Type = 496, Length = 4, Precision = 0, Scale = 0, CCSID = 0, UDTName = ---- INTEGER NOT NULL
Label = , Name = REGEFHIN, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REMSDS, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REIUPAC, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RESTRFO, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REMOLGEW, Type = 485, Length = 1026, Precision = 4, Scale = 2, CCSID = 0, UDTName = ---- DECIMAL(4 , 2)
Label = , Name = RESUFO, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RECASNR, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RESYN, Type = 457, Length = 3000, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RESUNAME, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = REIDNR, Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
Label = , Name = RESUID, Type = 496, Length = 4, Precision = 0, Scale = 0, CCSID = 0, UDTName = ---- INTEGER NOT NULL

===== SQLAM ================= 00000600/0000041C == Wed Oct 27 15:31:11.37 2004
Receiving Result Set column definitions

Result Set column definitions
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'0F', DB2 Type = 485, Length = 1026, Precision = 4, Scale = 2, CCSID = 0, UDTName = ---- DECIMAL(4 , 2)
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 3000, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'02', DB2 Type = 496, Length = 4, Precision = 0, Scale = 0, CCSID = 0, UDTName = ---- INTEGER NOT NULL
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'0F', DB2 Type = 485, Length = 1026, Precision = 4, Scale = 2, CCSID = 0, UDTName = ---- DECIMAL(4 , 2)
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 3000, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'35', DB2 Type = 457, Length = 300, Precision = 0, Scale = 0, CCSID = 273, UDTName = ---- LONG VARCHAR
DRDA Type = x'02', DB2 Type = 496, Length = 4, Precision = 0, Scale = 0, CCSID = 0, UDTName = ---- INTEGER NOT NULL

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.38 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

CNTQRY(
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0066')),
QRYBLKSZ(x'00007FFF'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.39 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

QRYDTA(Data at x'0134D268')
----------------------- Buffer at address x'0134D268' ------------------------
0000 FF00FFFF FFFF0000 132F0000 08C3F1F0 >........./......< >.............C10<
0010 C8F1F2E7 E7000009 F3F2F360 F4F260F2 >...........`..`.< >H12XX...323-42-2<
0020 F3000030 F360C8A8 849996A7 A860F460 >...0.`.......`.`< >3...3-Hydroxy-4-<
0030 A7A70D25 F3604DF3 60C8A884 9996A7A8 >...%.`M.`.......< >xx..3-(3-Hydroxy<
0040 60F46094 85A38896 A7A89788 8595A893 >`.`.............< >-4-methoxyphenyl<
0050 5D60A7A7 00000EC9 A2968685 99A49381 >]`..............< >)-xx...Isoferula<
0060 A2C0A499 85000012 D7D9E2E3 60C9C6C1 >............`...< >s{ure...PRST-IFA<
0070 60F0F2F1 F3F9F1F2 F3F40000 0001FFFF >`...............< >-021391234......<
0080 FFFF0000 132F0000 08C3F1F0 C8F1F2E7 >...../..........< >.........C10H12X<
0090 E7000009 F3F2F360 F4F260F2 F3000030 >.......`..`....0< >X...323-42-23...<
00A0 F360C8A8 849996A7 A860F460 A7A70D25 >.`.......`.`...%< >3-Hydroxy-4-xx..<
00B0 F3604DF3 60C8A884 9996A7A8 60F46094 >.`M.`.......`.`.< >3-(3-Hydroxy-4-m<
00C0 85A38896 A7A89788 8595A893 5D60A7A7 >............]`..< >ethoxyphenyl)-xx<
00D0 00000EC9 A2968685 99A49381 A2C0A499 >................< >...Isoferulas{ur<
00E0 85000012 D7D9E2E3 60C9C6C1 60F0F2F1 >........`...`...< >e...PRST-IFA-021<
00F0 F3F9F1F2 F3F40000 0001 >.......... < >391234.... <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.45 2004
Sending

RQSDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

PRPSQLSTT(
RTNSQLDA(True),
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0004')))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.46 2004
Sending

OBJDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = False
Continue on error = False

SQLSTT(Data at x'013CFBD8')
----------------------- Buffer at address x'013CFBD8' ------------------------
0000 00000036 E2C5D3C5 C3E340D9 C5D9C5E2 >...6......@.....< >....SELECT RERES<
0010 C3E4C540 C6D9D6D4 40C8C9D3 C6E2E2E3 >...@....@.......< >CUE FROM HILFSST<
0020 D64BD9C5 D9C5E2C3 E4C540E6 C8C5D9C5 >.K........@.....< >O.RERESCUE WHERE<
0030 40D9C5E2 E4C9C440 7EF1 >@......@~. < > RESUID =1 <
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.46 2004
Sending

RQSDSS
Correlator = x'0002'
Chained to next DSS = False
Next DSS has same correlator = False
Continue on error = False

OPNQRY(
PKGNAMCSN(
Location("PLANTAAS"),
Collection ID("NULLID"),
Package name("RAARDBX3"),
ConsistencyToken(x'0000000000000031'),
SectionNumber(x'0004')),
QRYBLKSZ(x'00007FFF'),
OUTOVROPT(x'01'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.47 2004
Received

OBJDSS
Correlator = x'0001'
Chained to next DSS = True
Next DSS has same correlator = False
Continue on error = False

SQLDARD(Data at x'013DB108')
----------------------- Buffer at address x'013DB108' ------------------------
0000 FF000100 00000000 00000000 00012C01 >..............,.< >................<
0010 C9011100 000008D9 C5D9C5E2 C3E4C500 >................< >I......RERESCUE.<
0020 000008D9 C5D9C5E2 C3E4C500 000000FF >................< >...RERESCUE.....<
------------------------------------------------------------------------------

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.65 2004
Received

RPYDSS
Correlator = x'0002'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

OPNQRYRM(
SVRCOD(x'0000'),
QRYPRCTYP(x'2417'))

===== DDM =================== 00000600/0000041C == Wed Oct 27 15:31:11.65 2004
Received

OBJDSS
Correlator = x'0002'
Chained to next DSS = True
Next DSS has same correlator = True
Continue on error = False

QRYDSC(Data at x'013CFAB0'),
QRYDTA(Data at x'013DB680')
----------------------- Buffer at address x'013CFAB0' ------------------------
0000 0676D035 012C0971 E0540001 D0000106 >.v.5.,.q.T......< >..}.....\...}...<
0010 71F0E000 00 >q.... < >.0\.. <
------------------------------------------------------------------------------
----------------------- Buffer at address x'013DB680' ------------------------
0000 FF000000 49C4A499 838840E2 83889381 >....I.....@.....< >.....Durch Schla<
0010 876B40D9 858982A4 95876B40 C685A485 >.k@.......k@....< >g, Reibung, Feue<
0020 99409684 85994081 95848599 8540E9D0 >.@....@......@..< >r oder andere Z}<
0030 958498A4 85939385 954085A7 979396A2 >.........
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

evr72
  • Locked
  • Question Question
Update field from one table with a join table
Replies
1
Views
583
evr72
evr72
MohanV
  • Locked
  • Question Question
Using table functions in Query
Replies
5
Views
653
fredericofonseca
fredericofonseca
pratimsingha
  • Locked
  • Question Question
Alternative of Select count(*) from TABLE
Replies
0
Views
457
pratimsingha
pratimsingha
usr1234
  • Locked
  • Question Question
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
Replies
0
Views
386
usr1234
usr1234
SE2097
  • Locked
  • Question Question
IBM DB2 On Cloud - How is table column name formatted?
Replies
0
Views
320
SE2097
SE2097

Part and Inventory Search

Sponsor

Back
Top