REXX- delete query in REXX

dbzTHEdinosauer · Posted: Thu Jun 28, 2012 5:40 pm

with any REXX script, use TRACE
before you annoy us with your Rookie BS.

Nic Clouston · Posted: Thu Jun 28, 2012 6:29 pm

Where is the WHERE in your code?

Pandora-Box · Posted: Thu Jun 28, 2012 8:12 pm

Whenever I write REXX + SQL programs I display the built query and copy that and try executing it in SPUFI

By doing that you could atleast ensure the syntax of SQL is correct

You have give the display but did you try to EXECUTE the displayed result in SPUFI

pshongal · New User Joined: 14 Jun 2012 Posts: 96 Location: India

Hi Nic,
Its typo, I have missed. I have given it in my query.

Hi Pandora-Box,
I did exactly the same way as you said using QMF. It does work.

Pandora-Box · Posted: Fri Jun 29, 2012 10:42 am

Is your rexx program working?

If yes , Moderators please lock it

pshongal · New User Joined: 14 Jun 2012 Posts: 96 Location: India

Hi Pandora-Box,

REXX pgm is not working. But anyways.. I will try to dig more and try to find solution. If I find something, I will post the solution.

Thanks to all for your responce.

Nic Clouston · Posted: Fri Jun 29, 2012 12:48 pm

Do not re-type your code - cut and paste it. That way you stop people looking at rubbish introduced by your re-typing. Instead they can look at what you actually run. And you were asked some time ago to run with a trace and pst the results and you have shown no evidence of having done that.

Pedro · Posted: Mon Jul 02, 2012 9:49 pm