Re: SQL Want run.

Bob,

The SELECT INTO form can only be used when a single row is being returned.

Since you're using LIKE, I'd imagine that more than one row would be
returned.

Thus, you can't use SELECT INTO.

From the manual:

"The SELECT INTO statement produces a result table consisting of at most
one row, and assigns the
values in that row to host variables. If the table is empty, the statement
assigns +100 to SQLCODE and
'02000' to SQLSTATE and does not assign values to the host variables. If
more than one row satisfies
the search condition, statement processing is terminated, and an error
occurs."

HTH,

Charles

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob Bledsoe
Sent: Thursday, August 09, 2007 12:06 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL Want run.

This code doesn't run. It complies fine but if you step
through it in debug it goes to the end with running the SQL.
SQLCODE OF SQLCA = 1077952576 which if I understand correctly
is just garbage in the field before the SQL is run. Can
anyone tell me what I've done wrong?

0130.00 addres = '%1811 CLEAR%';
0131.00 /End-Free
0132.00
0133.00 C/EXEC SQL
0134.00 C+ select a.primary_no, a.pre_d00001, a.stree00001, a.suffix,
0135.00 C+ a.secon00001
0136.00 C+ INTO :crprimno:nullt1, :crpredir:nullt2,
0137.00 C+ :crstrnm:nullt3, :crsufix:nullt4,
0138.00 C+ :crqulf:nullt5
0139.00 C+ from "INNOPFLS"/"ADDRESS" a
0140.00 C+ where a.addr1 like :addres
0141.00 c+ order by a.stree00001
0142.00 C/END-EXEC
--
This is the RPG programming on the AS400 / iSeries (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

This e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are not a
named addressee you are hereby notified that you are not authorized to read,
print, retain, copy or disseminate this communication without the consent of
the sender and that doing so is prohibited and may be unlawful. Please
reply to the message immediately by informing the sender that the message
was misdirected. After replying, please delete and otherwise erase it and
any attachments from your computer system. Your assistance in correcting
this error is appreciated.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.