× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Dave -
I missed a step...
Here is a correction to my original statement (has vertical bar in front):

----------------------------------------------------------------------

You need to change your ODBC data source.

It is trying to use commitment control,
which expects the file to be journaled.

This is probably what SQL7008 is indicating.

Go into Administrative Tools > Data Sources (ODBC),
| Select the data source that you are using and click Configure,
then click on the Server tab, then click the Advanced button
at the bottom of the panel.  On the next panel, in the Commit mode:
drop-down box, select "Commit immediate (*NONE)" and
click Ok.

This should fix your problem, given that none of the text fields
in your Access database are longer than the corresponding
fields in the AS/400 file.

Regards,
Steve


----- Original Message ----- 
From: <>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, December 02, 2004 12:50 PM
Subject: Re: ODBC Access?


>
>
>
>
> Steve,
>
> Thanks.  That was a good idea.  I ran a query on the Access table to check
> all of the fields for null values.  There were a couple of records with
> nulls and I assigned values to them.  There are now no nulls.
> Unfortunately, it still does not work.  I still get the original error but
> now I also get a dialogue box that reads:
>
>  [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - EXTRACT in DPLIB not
> valid for operation. (# - 7008)
>
> There are ten fields in the table that are all text.  There are ten fields
> in the DB2 file that are also all text with the same field lengths.  I may
> have to try a different approach.
>
> Dave Parnin
> Nishikawa Standard Company
> Topeka, IN  46571
> daparnin@xxxxxxxxxxxxxxxxxx
>
>
>
>
>
>                       Steve Landess
>                       <sjl_abc@hotmail.        To:       Midrange Systems
Technical Discussion
>                       com>
<midrange-l@xxxxxxxxxxxx>@SMTP@CTB
>                                                cc:       David A
Parnin/Topeka/NISCO/SPCO@SPCO
>                       12/02/2004 11:39         Subject:  Re: ODBC Access?
>                       AM
>
>
>
>
>
> Dave -
>
> Do you have any columns in the Access table containing null values?
> If the corresponding fields in the AS/400 file don't allow nulls,
> you will encounter this error.
>
> I had a similar problem when uploading data from an Access table,
> and I wrote a VB function that I used in my Select statement
> within the Access database to substitute blanks for nulls in alpha fields
> and zeros for nulls in numeric fields.
>
> Steve
>
> ----- Original Message -----
> From: <>
> To: <midrange-l@xxxxxxxxxxxx>
> Sent: Thursday, December 02, 2004 10:04 AM
> Subject: ODBC Access?
>
>
> >
> >
> >
> >
> > Can anybody tell me what I need to change on the iSeries to accept an
> ODBC
> > upload from a MS-Access database?  I can open the file in Access as a
> > link-table but if I try to add to it I get a message that reads
> > "ODBC--insert on linked table 'DPLIB_EXTRACT' failed.
> >
> > This is a one-shot project so in the interest of security anything that
> > turn on I can turn off once it's done.  Thanks.
> >
> > Dave Parnin
> > Nishikawa Standard Company
> > Topeka, IN  46571
> > daparnin@xxxxxxxxxxxxxxxxxx
> >
> > --
> > 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.
>
>

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.