Jay:

I don't think you'll "restore" the environment variables, just set them
back to what they were before you changed them using the same command.

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On Mon, Apr 18, 2022 at 10:19 AM Colin Williams <colinwilliams007@xxxxxxxxx>
wrote:

Good that you got it figured out.

Not sure what you mean by your WRKENVVAR question? You mean you want to
know how to set environment variables?

Cheers
Colin

On Sun, 17 Apr 2022, 23:16 Jay Vaughn, <jeffersonvaughn@xxxxxxxxx> wrote:

thank you Colin... got it figured out thanks to you.

I did not have a dependent .jar file placed here...

/QIBM/UserData/OS400/SQLLib/Function/jar

works now... but on a different note... If I made changes to the
WRKENVVAR
for *SYS and *JOB, how is best way to recover those changes?
Do I need a system backup for that?

Jay

On Sun, Apr 17, 2022 at 8:13 AM Colin Williams <
colinwilliams007@xxxxxxxxx

wrote:

Where are you running this from?

Do a strdbg first and then run this on ibmi and if you are lucky you
might
get more information in the joblog.

If its a java udf that's dependent on another class, has the class path
been setup correctly. Have the required classes been added to the class
path?

https://www.ibm.com/support/pages/class-path-used-java-procedures

If its running fine on another system compare the setup for both and
see
what's different/missing

Cheers
Colin

On Sun, 17 Apr 2022, 13:01 Jay Vaughn, <jeffersonvaughn@xxxxxxxxx>
wrote:

Thanks Colin.

Yes a valid json formatted string.
I do have the code.
Nothing more in the job log unfortunately.
I’ll try and post the extended help on the error.
I run this same udf on a different ibm i passing it the same string
and
it
works fine.

I think it’s an installation or run time environment issue. But not
sure
where to go for that stuff or what to consider.

Jay


On Apr 17, 2022, at 7:00 AM, Colin Williams <
colinwilliams007@xxxxxxxxx>
wrote:

Sounds like a problem with the underlying UDF you are calling.

Do you have the code for it? Anything else in your joblog?

What is the code doing? If its processing a json file or string you
might
want to check that the format is valid.

On Sat, 16 Apr 2022, 23:41 Jay Vaughn, <jeffersonvaughn@xxxxxxxxx

wrote:

I am personally not a knowledgeable IBM i java developer.

I can provide more info but anyone know what this may mean?

In strsql, I'm simply invoking an sql statement that calls a UDF
that
calls
a java something or the other. :)

Java stored procedure or user-defined function COREIRST.JSON2XML,
specific
name JSON2XML_CLOB aborted with an exception
"org.json.JSONObject".
sqlstate 38000

tia

Jay
--
This is the Java Programming on and around the IBM i (JAVA400-L)
mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com

--
This is the Java Programming on and around the IBM i (JAVA400-L)
mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com
--
This is the Java Programming on and around the IBM i (JAVA400-L)
mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com

--
This is the Java Programming on and around the IBM i (JAVA400-L)
mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.