Closed kadler closed 6 years ago
Original comment by Brian Jerome (Bitbucket: bjerome, GitHub: brianmjerome).
Thanks. The other PGMs I've marked with this issue were all running successfully now with the SQL call.
The experimental is still getting the Illegal instruction - core dumped
-- but that might be another issue (from me who knows yet). I'll mark resolved for now!
Original comment by Tony Cairns (Bitbucket: rangercairns, GitHub: rangercairns).
Ok, new fix version. Fix problem with arrays out packed/zoned (dim > 1). Also, ILE proc side, input no "value":"" default "name":"outArray" (ok on PASE, bad ILE).
Yips Super Driver - test driver - 1.1.4-sg15 toolkit array s records error packed/zoned (Brian)
#!bash
bash-4.3$ ./test4000_sql400json_procj32 ../json/j0150_pgm_brian01-s-dim
input(5000000):
{"pgm":[{"name":"BRIAN01","lib":"DB2JSON"},
{"s":{"name":"inputOne","type":"8p0","by":"in","value":""}},
{"s":{"name":"outArray","type":"8p0","by":"out","dim":100}},
{"s":{"name":"bothArray","type":"8p0","by":"both","dim":100,"value":""}},
{"ds":[
{"name":"outDS","by":"out","dim":100,"dou":"outCount"},
{"s":[
{"name":"outputA","type":"7a"},
{"name":"outputB","type":"1a"}
]}
]},
{"s":{"name":"outCount","type":"10i0","by":"out"}},
{"s":{"name":"last","type":"8a","by":"out"}}
]}
output(948):
{"script":[{"pgm":["BRIAN01","DB2JSON",{"outArray":
[0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]},
{"bothArray":[0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]},
{"outDS":[[{"outputA":""},{"outputB":""}]]},
{"outCount":1},
{"last":"last"}]}]}
result:
success (0)
BTW -- Apologies, I named some of your good contribute rpg tests 'Danny' (i think). I will try to keep issue finder names straight in future (try, i say).
Original report by Brian Jerome (Bitbucket: bjerome, GitHub: brianmjerome).
I'm not sure exactly what could be causing this. I am getting an
Illegal instruction
error using the experimental toolkit and running sql directly results in the following error message:Here's the test PGM:
Test JSON input:
No output should be expected -- just created this to reproduce the error. I think it might have something to do with the "bothArray" param.