Activity Stream

Can you clarify that? Does it mean that the 'toolkit' already is present as part of Zend Server on i? Tom

So, Stored procedures are perfectly fine, especially if you are accessing business logic from off platform. So now that you have them, consider them...

You can do this other than by adding the job manually again. You need to restore QUSRIJS to another library. Add that library as a data library...

Dangerous Hicks! That was a nice Jeep. I would like to review the claim report.

It looks okay to me. There are many options you can specify to do different things... hard to say whether they are "right" or "wrong", it depends...

Dude -- Thats not me! That's Santa Clause... I know better than to floor it on mud.

yep. It did ....

If procedure are close to functions then the only way I can see them is by using ops nav. Even If i drill down by using wrklnk /qsys.lib/mylib.lib ...

Can you provide a list of functions that you need to be able to do? Adopted authority programs can get just about everything done without needing...

Ya but does it work. And by work I don't mean handling the error message but does the alter table still happen?

Scott & Barbara, thank you again for your responses. To answer your question Scott, this encryption/decryption is within a purchased package we...

I learned a lot now. Since I have no direct contact with the Java people, I tried to simulate their case. After long investigation I can out...

I'm getting somewhere, thanks Scott. I created a stored procedure (more by the seat of my pants than anything else) using STRSQL, and the call: ...

Thanks everyone, and thanks for responding Scott, you at least know this area of the AS400 inside out. While I have worked on AS400 for 13 years, my...

Ah, yes. I thought there might be a reason I didn't do it. It was long enough ago that I couldn't remember *BYVAL and V5R3. I made one many years...

But... Java typically uses the JDBC library to run SQL statements. That's a completely different animal than QShell. No matter what we teach you...

V5R3 is the first release where you can call SQL CLI directly from CL (you need the *BYVAL keyword on CALLPRC, which was added in V5R3). Not too...

I am running code in version 6 and 7. The code is actually invoked by Java, which runs SQL ALTER statement. The issue was raised - when their...

I'm not clear on what means. It makes it seem as if you can't make any changes to the code. So, what exactly are you needing for help? In short,...

Try getting a Java exception trace so you can see which Java class is actually getting the exception. ADDENVVAR QIBM_RPG_JAVA_EXCP_TRACE...

When calling Java, the fact that the error is an RNQ0301 means very little, since that message ID is used for all errors reported by Java (and there...

I wasn't replying to you, I was replying to DeadManWalks. As near as I can tell, it has nothing to do with naming convention. It also has...

it's just a little dent :D good to see you walk away unscathed

Oh! I should have mentioned this, we are running OS V5R4 currently. PTFs are up to date.

But the issue raised here is trap of SQL code / Inquiry message code in QSH. What does it have to do with naming convention ? Sorry. Do I...

What you're doing here is calling the QCMDEXC API as a stored procedure, and then passing it a command string to call a program. Seems rather...

The QShell 'db2' command does not have any support for SYS naming convention... only SQL. I wrote my own replacement command for QShell that does...