Transfer Data from iSeries to Excel
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 8, 2006 12:36 PM
UPDATED:
December 1, 2009 7:01 AM
Answer Wiki:
Did you use the single quotes in the transfer from EXCEL?
To see all answers submitted to the Answer Wiki: View Answer History.
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')
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.
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.
is also valid. However, the processing of quotes will depend on the client.
Tom