Home > IT Answers > AS/400 > Data Transfer Field Description Names
Cyd
35 pts.
 Data Transfer Field Description Names
AS/400 data transfer, Data transfer, iSeries Data Transfer, V4R5
On the data transfer box you can choose the data options button which you can then go to details button. In choosing that button you get to the Receive Requested Details box. My questions is how do I change the Field Description name to what I need it to be when the file is downloaded.

Software/Hardware used:
iSeries R5V4 data transfer and Excel 2007
ASKED: August 30, 2011  6:50 PM
UPDATED: March 31, 2012  5:18 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

…when the file is downloaded.

What is the file being downloaded as? Is this a transfer using the Excel add-in?

In the column list of the SELECT statement, add the {as IDENTIFIER} clause to any column that you want to identify differently.

So, if your SELECT statement begins with {SELECT COLUMN1, COLUMN2…} and you wanted COLUMN1 to come across as My1stField, you would change the statement to begin with {SELECT COLUMN1 as My1stField, COLUMN2…}. If case must be preserved, you can enclose My1stFld in double-quotes but the quotes become part of the name.

There might be alternatives, but it’s not completely clear what you need to accomplish.

Tom

TomLiotta
 107,915 pts.