Hi,
I'm missing the semi colons (;) that end an SQL statement.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[
mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
daparnin@xxxxxxxxxxxxxx
Gesendet: Tuesday, April 03, 2007 20:17
An: midrange-l@xxxxxxxxxxxx
Betreff: Problem creating a file with RUNSQLSTM
I've created files a few times before using SQL instead of DDS. I'm
working on a project now where I decided to put the SQL inside of a source
member and use RUNSQLSTM to execute it. The problem is I get a "RUNSQLSTM
command failed" message with no further detail in the job log. I'm trying
to put multiple statements in the same member. Is that a problem? The
execute just fine when I do them individually in STRSQL.
This is what the source member looks like:
CREATE TABLE DPWORK3/POLEFL (
PLCOMP Char (2) NOT NULL WITH DEFAULT,
PLFROUTQ Char (10) NOT NULL WITH DEFAULT,
PLFRLIB Char (10) NOT NULL WITH DEFAULT,
PLTOOUTQ Char (10) NOT NULL WITH DEFAULT,
PLTOLIB Char (10) NOT NULL With Default,
PLTOUSERID Char (10) Not Null With Default,
PLACTION Char (1) Not Null With Default)
LABEL ON COLUMN DPWORK3/POLEFL (
PLCOMP is 'Company',
PLFROUTQ is 'From OUTQ',
PLFRLIB is 'From Library',
PLTOOUTQ is 'To OUTQ',
PLTOLIB is 'To Library',
PLTOUSERID is 'To User-ID',
PLACTION is 'Action')
LABEL ON COLUMN DPWORK3/POLEFL (
PLCOMP Text is 'Company',
PLFROUTQ Text is 'From Output Queue',
PLFRLIB Text is 'From Library',
PLTOOUTQ Text is 'To Output Queue',
PLTOLIB Text is 'To Library',
PLTOUSERID Text is 'To User-ID',
PLACTION Text is 'Action: Move, Send, Both')
Any thoughts would be appreciated.
Dave Parnin
midrange.com
