Transfer Data from iSeries to Excel
Home > IT Answers > AS/400 > Transfer Data from iSeries to Excel
CasNowak
0 pts.
0
Q:
Transfer Data from iSeries to Excel
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: Mar 8 2006  12:36 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
JBurelle
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Did you use the single quotes in the transfer from EXCEL?
Last Answered: Mar 8 2006  1:27 PM GMT by JBurelle   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

JPLamontre   0 pts.  |   Mar 9 2006  7:49AM GMT

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')

 

CasNowak   0 pts.  |   Mar 9 2006  1:18PM GMT

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.

 

geneburns   15 pts.  |   Mar 10 2006  12:26PM GMT

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.

 
0