MVSFORUMS.com

Thank you, yes, I've read that IBM article last week. It didn't help me solve my problem.

I don't know how to attach screenshots. I have attempted to copy/paste them into this box where I type these words, but it doesn't work. I don't see an option that allows me to attach documents.

...

My PC was re-imaged with Windows 10 64-bit and MS Office 64-bit at the same time.

Last week, using IBM Data Studio 4.1.3, I was able to connect to z/OS DB2 when I was given temporary Admin rights, ...

Hi, I'm getting an error when I attempt to connect to z/OS DB2 from MS Access.

My PC is running Windows 10 64-bit Build 16299 and Microsoft Access 2016 MSO (16.0.8431.2046) 64-bit.

I have chec ...

Ah, I missed in the manual under FETCH it clearly says:

This statement can only be embedded in an application program. It is an executable statement that cannot be dynamically prepared. Multiple ...

I got an answer from IDUG.ORG. I needed to replace the "WITH ROWSET POSITIONING" with a REXX variable ":SQLATTR" that contained the "WITH ROWSET POSITIONING" string. We ...

I am attempting to write a REXX program that will execute a DB2 MultiFetch; getting an SQLCODE = -104 on the PREPARE statement. I've removed the error-trapping logic in the below code to make it easi ...

I figured it out...by reading the manual more slowly and finally noticed it does not say IMMEDIATE when you use a PREPARE. I could not get it to work using EXECUTE IMMEDIATE.

This works:
sqlstmt ...

I have a REXX DB2 program where I'd need to execute a SET SCHEMA statement; however no matter what I try I get an SQLCODE = -104. The "DB2 Programming and Application Guide" (for z/OS DB2 v ...

To use PFKeys in a panel I used to just override them with code in the REXX program that displays the panel by hard-setting them to whatever value I wanted, and then resetting them when the program en ...

Hi Kolusu, No response from Frank. Maybe my email went into his Junk mail folder since it is a GEICO email address. Anyway, I figured out how to do what I wanted to do without using an Editor Profi ...

Okay, so I discussed this with one of my co-workers and she immediately said that makes sense, that the Execute Immediate would work but the Prepare wouldn't because of the BIND Validate(Run|Bind) par ...

Actually his message says he'd be happy to answer any questions...it's just he didn't leave his email address.

I have retired from IBM and much of the MVS related content on this site was developed ...

But why are you preparing the statement? If it works the other way, why not use it? I suppose you're trying to not flood the dynamic cache.

I tried your example and sure enough I get the same er ...

misi01,

Actually even though I read all the posts...twice...I still don't quite understand everything you're saying/showing. So I just coded it the way I would. This is a primitive example, wher ...