RE: [sqr-users] help

["Alexander, Steve" <Steve.Alexander@ci.sj.ca.us>]

I'm not entirely sure what you mean, but it sounds like you need five
inserts:

begin-sql

insert into dbtable values ($type_sch, $level, $grade, $step1);
insert into dbtable values ($type_sch, $level, $grade, $step2);
insert into dbtable values ($type_sch, $level, $grade, $step3);
insert into dbtable values ($type_sch, $level, $grade, $step4);
insert into dbtable values ($type_sch, $level, $grade, $step5);

end-sql

Normally, you'd list the field names after the table name and before the
keyword "value," but it isn't necessary if the values are in the order of
the fields in the record layout.

-----Original Message-----
From: Robin Ferebee [mailto:Robin_Ferebee@nexnet.navy.mil]
Sent: Monday, March 24, 2003 1:16 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] help


Hello anyone:

      I am writing an SQR where I am reading from a flat file with 5 fields
that are different, but each are the same in the database. (ex. UNSTRING
$RECORD BY '|' INTO $NX_PAY_SCHD $TYPE $SN
     $TYPE_SCH $LEVEL $GRADE $STEP1 $SPACE1 $STEP2 $SPACE2 $STEP3 $SPACE3
$STEP4 $SPACE4 $STEP5 $SPACE5 $EDATE). I am trying to insert into the
database using a while loop reading one record per line from this flat
file, but I have one data base field (hourly_rate) and five different
fields(step1-step5) referring to this one database field.  I can't seem to
get the fields inserted into the database. Please give some examples as to
how to go about this.



Thanks.


Robin S. Ferebee
PeopleSoft Group
Navy Exchange Service Command
(757) 631-3347




***************************defiant************************************
This email and any files transmitted with it are intended solely for 
the use of the individual or agency to whom they are addressed. If 
you have received this email in error please notify the Navy Exchange
Service Command e-mail administrator.

This footnote also confirms that this email message has been scanned 
for the presence of computer viruses.

messaging_support_team@nexnet.navy.mil
**********************************************************************

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users