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 "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.
cfquery name="NewRequest" datasource="OIMDBADM"
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#')
/cfquery
--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=listsbody=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=listsbody=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 "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.
cfquery name="NewRequest" datasource="OIMDBADM"
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#')
/cfquery
--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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 "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.
cfquery name="NewRequest" datasource="OIMDBADM"
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#')
/cfquery
--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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
