Re: Need some help here, unknown error SQL 7008N
Jim: A couple of points -- "Reilly, Jim" wrote: > > James, > > REXX is an IBM programming language (runs interpretative, not compiled), > and runs on all IBM OS's like AS400, OS/2, VM, MVS, etc... > REXX is to those OS's as Basic is to DOS, yet has some parsing > power of perl. > Actually, there are REXX compilers for VM (since 1989), MVS and PC platforms (yes, I'm a longtime user of REXX). However, more interesting is why James is getting this error. I know nothing about the AS/400 really, or the DBs that run on it. I am a big user of DB/2 on the mainframe. DB/2 comes with RxSQL, which allows you to write SQL apps against the DB in the REXX language. The only way I can think of this error occurring on the MF is to execute an RxSQL program that had some sort of problem, which is what SQLDA (SQL data area) is complaining about, and ASSume that there is a comparable situation on his AS/400. >From the code James has below, it looks like a standard CF insert, I ASSume (again) the connection to the DB is either via a native or ODBC driver. As such, this error should not be received. James' best bet would be to speak to the DBA. -Gerry Gerard T. Pauline Mgr, Internet/DB Applictions Computer Systems, DoIT Pace University > Anyway, sound like the datatypes are incorrectly passed from your > SQL statements to the types of the database fields. (ie: if > ID is numeric remove the ' ' and/or the date fields are Date type, > then also remove the ' ', thus: > '#date#' becomes '#date# and > '#form.id#' becomes #form.id# > > Hope this helps! > > Jim > > -Original Message- > From: James Taavon [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 28, 2000 11:17 AM > To: CF-Talk > Subject: Need some help here, unknown error SQL 7008N > > This is a multi-part message in MIME format. > --327729A9AA7CC339FC1F4ECE > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > I checked to see what the error meant and it said this: > > SQL7008N REXX variable "" contains inconsistent data. > > Cause: A variable that contained inconsistent data was passed to REXX. > > The command cannot be processed. > > Action: If the variable is an SQLDA, verify that the data and length > fields have been assigned correctly. If it is a REXX variable, verify > that the type of data is appropriate to the command where it is being > used. > > What is a REXX varible anyway? > > I checked my data types and lengths and they all check out. What could > be causing this error??? I am using AS/400 on the back-end. > > > > insert into oimdbadm.newreq (time, date, agency, reqtype, > requester, req_email, phone, due_date, title, descrip, id, assigned) > values ('#time#', '#date#', '#form.agency#', '#form.reqtype#', > '#form.requester#', '#form.req_email#', '#form.phone#', > '#form.due_date#', '#form.title#', '#form.descrip#', '#form.id#', > '#form.assigned#') > > --327729A9AA7CC339FC1F4ECE > Content-Type: text/x-vcard; charset=us-ascii; > name="jtaavon.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for James Taavon > Content-Disposition: attachment; > filename="jtaavon.vcf" > > begin:vcard > n:Taavon;James > tel;cell:(443) 506-2117 > tel;fax:(410) 333-5203 > tel;work:(410) 767-3415 > x-mozilla-html:FALSE > org:Department of Labor, Licensing and Regulation;Office of Information and > Technology > version:2.1 > email;internet:[EMAIL PROTECTED] > title:Senior Web Developer > adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom > 203;Baltimore;MD;21201; > fn:James Taavon > end:vcard > > --327729A9AA7CC339FC1F4ECE-- > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Need some help here, unknown error SQL 7008N
This is a multi-part message in MIME format. --F68D756517EC607E868C5C20 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Jim, Weird. While I would never do this, I decided to drop and re-create the table since it was only 12 columns. After I did that, it worked like a champ. Anyway, thanks for the tip, I will keep it in mind for the future. James "Reilly, Jim" wrote: > > James, > > REXX is an IBM programming language (runs interpretative, not compiled), > and runs on all IBM OS's like AS400, OS/2, VM, MVS, etc... > REXX is to those OS's as Basic is to DOS, yet has some parsing > power of perl. > > Anyway, sound like the datatypes are incorrectly passed from your > SQL statements to the types of the database fields. (ie: if > ID is numeric remove the ' ' and/or the date fields are Date type, > then also remove the ' ', thus: > '#date#' becomes '#date# and > '#form.id#' becomes #form.id# > > Hope this helps! > > Jim > > -Original Message- > From: James Taavon [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 28, 2000 11:17 AM > To: CF-Talk > Subject: Need some help here, unknown error SQL 7008N > > This is a multi-part message in MIME format. > --327729A9AA7CC339FC1F4ECE > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > I checked to see what the error meant and it said this: > > SQL7008N REXX variable "" contains inconsistent data. > > Cause: A variable that contained inconsistent data was passed to REXX. > > The command cannot be processed. > > Action: If the variable is an SQLDA, verify that the data and length > fields have been assigned correctly. If it is a REXX variable, verify > that the type of data is appropriate to the command where it is being > used. > > What is a REXX varible anyway? > > I checked my data types and lengths and they all check out. What could > be causing this error??? I am using AS/400 on the back-end. > > > > insert into oimdbadm.newreq (time, date, agency, reqtype, > requester, req_email, phone, due_date, title, descrip, id, assigned) > values ('#time#', '#date#', '#form.agency#', '#form.reqtype#', > '#form.requester#', '#form.req_email#', '#form.phone#', > '#form.due_date#', '#form.title#', '#form.descrip#', '#form.id#', > '#form.assigned#') > > --327729A9AA7CC339FC1F4ECE > Content-Type: text/x-vcard; charset=us-ascii; > name="jtaavon.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for James Taavon > Content-Disposition: attachment; > filename="jtaavon.vcf" > > begin:vcard > n:Taavon;James > tel;cell:(443) 506-2117 > tel;fax:(410) 333-5203 > tel;work:(410) 767-3415 > x-mozilla-html:FALSE > org:Department of Labor, Licensing and Regulation;Office of Information and > Technology > version:2.1 > email;internet:[EMAIL PROTECTED] > title:Senior Web Developer > adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom > 203;Baltimore;MD;21201; > fn:James Taavon > end:vcard > > --327729A9AA7CC339FC1F4ECE-- > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --F68D756517EC607E868C5C20 Content-Type: text/x-vcard; charset=us-ascii; name="jtaavon.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for James Taavon Content-Disposition: attachment; filename="jtaavon.vcf" begin:vcard n:Taavon;James tel;cell:(443) 506-2117 tel;fax:(410) 333-5203 tel;work:(410) 767-3415 x-mozilla-html:FALSE org:Department of Labor, Licensing and Regulation;Office of Information and Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Senior Web Developer adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom 203;Baltimore;MD;21201; fn:James Taavon end:vcard --F68D756517EC607E868C5C20-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Need some help here, unknown error SQL 7008N
James, REXX is an IBM programming language (runs interpretative, not compiled), and runs on all IBM OS's like AS400, OS/2, VM, MVS, etc... REXX is to those OS's as Basic is to DOS, yet has some parsing power of perl. Anyway, sound like the datatypes are incorrectly passed from your SQL statements to the types of the database fields. (ie: if ID is numeric remove the ' ' and/or the date fields are Date type, then also remove the ' ', thus: '#date#' becomes '#date# and '#form.id#' becomes #form.id# Hope this helps! Jim -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 11:17 AM To: CF-Talk Subject: Need some help here, unknown error SQL 7008N This is a multi-part message in MIME format. --327729A9AA7CC339FC1F4ECE Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I checked to see what the error meant and it said this: SQL7008N REXX variable "" contains inconsistent data. Cause: A variable that contained inconsistent data was passed to REXX. The command cannot be processed. Action: If the variable is an SQLDA, verify that the data and length fields have been assigned correctly. If it is a REXX variable, verify that the type of data is appropriate to the command where it is being used. What is a REXX varible anyway? I checked my data types and lengths and they all check out. What could be causing this error??? I am using AS/400 on the back-end. insert into oimdbadm.newreq (time, date, agency, reqtype, requester, req_email, phone, due_date, title, descrip, id, assigned) values ('#time#', '#date#', '#form.agency#', '#form.reqtype#', '#form.requester#', '#form.req_email#', '#form.phone#', '#form.due_date#', '#form.title#', '#form.descrip#', '#form.id#', '#form.assigned#') --327729A9AA7CC339FC1F4ECE Content-Type: text/x-vcard; charset=us-ascii; name="jtaavon.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for James Taavon Content-Disposition: attachment; filename="jtaavon.vcf" begin:vcard n:Taavon;James tel;cell:(443) 506-2117 tel;fax:(410) 333-5203 tel;work:(410) 767-3415 x-mozilla-html:FALSE org:Department of Labor, Licensing and Regulation;Office of Information and Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Senior Web Developer adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom 203;Baltimore;MD;21201; fn:James Taavon end:vcard --327729A9AA7CC339FC1F4ECE-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.