Trying to use “Transfer data from iSeries add-on to Excel

0 pts.
Tags:
AS/400
SQL
I am trying to use 'Transfer data from iSeries' add-on from within Excel. I have specified my library/file as : <><><><><><><> TANFILE/NCUFFLDR Data Option as: Select NCUFFLDR_COMPANY_TYPE Where (NCUFFLDR_COMPANY_TYPE=M) <><><><><><><> I receive CWBDB0036 SQL0206... M is not a column of table *N in *N. If the table is *N, M is not a column of any table or view that can be referenced. On the iSeries it works with: <><><><><><><><> File = NCUFFLDR Library = TANFILE Member = *FIRST Format = NCUFFLDRR Select Records looks like this: Field = t02.COMPTYPE Test = EQ Value = 'M ' <><><><><><> The ouput on the iSeries looks like this: Comp Docket Sub Proceeding Type Number Number Date M 89 0 01/01/1998 M 100 1 09/02/1964 <><><><><><><> Can you tell me what I need to do with the add-on in Excel to get the same results?
ASKED: March 8, 2006  12:36 PM
UPDATED: August 28, 2013  2:52 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Did you use the single quotes in the transfer from EXCEL?

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JPLamontre
    You need to qualify M as a litteral, not a column name ie : this part Where (NCUFFLDR_COMPANY_TYPE=M) may be correctly understood when corrected : Where (NCUFFLDR_COMPANY_TYPE='M')
    0 pointsBadges:
    report
  • CasNowak
    My Where statement was wrong. I had to have quotes around 'M'. I also changed my date format to USA instead of MDY and it worked. In the iSeries I can specify text to describe columns, but with the transfer program all I can bring back are the alias names. Maybe that is a limitation of this Add-in. If anyone knows of a way to put more of a description on the columns, please respond.
    0 pointsBadges:
    report
  • Geneburns
    In your transfer setup, click on the Data Options button and change your selection to be something like this: field as Field_Name, lib as Library_Name This will use whatever you specify after the 'as' for the column names. Spaces are not valid though so underscores are usually used instead.
    15 pointsBadges:
    report
  • TomLiotta
    field as "Field Name", lib as "Library Name"
    is also valid. However, the processing of quotes will depend on the client. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following