Re: Assigning Multiple Variable Based On Table Row

["Ryan Hunt" <ryan.hunt@xxxxxxxxxxxxx>]

Alright...more progress.  I was apparently looking at the wrong syntax diag
for IF statement...found the right one.  So, I have successful syntax.
However, now I have a new message I have no idea about.  What is QSYSPRT and
how do I check it?

[SQL7032] SQL procedure, function, or trigger SPCONTACTIMPORT1 in DEVDTA not
created. Cause . . . . . :   SQL procedure, function, or trigger
SPCONTACTIMPORT1 in DEVDTA was not created. The compile was not successful.
SQL creates an SQL procedure, function, or trigger as a C program that
contains embedded SQL.  Errors not found during the initial parsing of the
CREATE PROCEDURE, CREATE FUNCTION, or CREATE TRIGGER statement can be found
during the precompile. Recovery  . . . :   If a compile error occurred, see
the precompiler listing in QSYSPRT.



"Wilt, Charles" <CWilt@xxxxxxxxxxxx> wrote in
message
news:57FCBE9213FC584692CAAECA3F59426F50B33E@xxxxxxxxxxxxxxxxxxxxxxxxxx
> I think I understand what you are trying to do....you're not even close.
>
>
> Take a look at the SELECT INTO statement in the SQL Reference.
>
>
> Charles Wilt
> --
> iSeries Systems Administrator / Developer
> Mitsubishi Electric Automotive America
> ph: 513-573-4343
> fax: 513-398-1121
>
>
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On
Behalf Of Ryan Hunt
> > Sent: Friday, August 18, 2006 8:05 AM
> > To: midrange-l@xxxxxxxxxxxx
> > Subject: Assigning Multiple Variable Based On Table Row
> >
> > How do you assign multiple variables at the same time on an
> > AS400?  I've
> > looked through the SQL reference for V5R2 and I'm not seeing
> > what I need.
> >
> > I am getting syntax errors on:
> >
> >   SELECT @STREET1=ADDRESS1, @STREET2=ADDRESS2, @CITY=CITY,
> > @STATE=STATE,
> > @ZIP=ZIP, @ADDRESSNAME=ADDRESSNAME, @ADDRESSTYPE=ADDRESSTYPE
> >  , @TENANTID=TENANTID, @LEASEID=LEASEID, @PHONENUMBER=PHONENUMBER,
> > @FAXNUMBER=FAXNUMBER, @FIRSTNAME=FIRSTNAME, @MIDDLENAME=MIDDLENAME
> >   , @LASTNAME=LASTNAME, @NICKNAME=NICKNAME, @SURNAME=SURNAME,
> > @SUFFIXNAME=SUFFIXNAME, @HIWCONTACTTYPE=CONTACTTYPE
> >   FROM DEVDTA.CONTACTIMPORT WHERE ID=@COUNTER;
> >
> > Thanks in advance.
> >
> >
> >
> > -- 
> > This is the Midrange Systems Technical Discussion
> > (MIDRANGE-L) mailing list
> > To post a message email:
MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email:
MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.