Re: Field names in SQL-generated files

Probably.

Something like this, where the SQL name is COLUMNNAME and AS400NME is the native name:

/* Creating table LENNONS1.TEST */
CREATE TABLE LENNONS1.TEST ( COLUMNNAME FOR AS400NME CHARACTER (10) ) ;

/* Setting column labels for LENNONS1.TEST */
LABEL ON COLUMN LENNONS1.TEST ( COLUMNNAME TEXT IS 'This is the text field text' );

/* Setting column headings for LENNONS1.TEST */
LABEL ON COLUMN LENNONS1.TEST ( COLUMNNAME IS 'Heading 1 Heading 2 Heading 3 ' );

If you have access to iSeries Navigator, you can use it to create SQL tables and other SQL related stuff. It's a "fill in the blanks" process, which is what I used on the above code, since I can never remember the syntax.

There is an article I wrote here if you need help finding the right menu in iSeries Nav:

http://www.mcpressonline.com/sql/prompted-sql-ddl-creation.html

Sam

On 8/22/2012 8:33 PM, James Lampert wrote:

We've got an SQL jock with little or no AS/400 experience developing an
entirely SQL-generated database for us (and in fact, that script that
was giving us trouble recently was part of it -- I passed along the
answers, and he was able to get the script working; thanks!).

At any rate, we're getting (not unexpectedly) SQL field names coming up
as column headings, looking at the file in QuestView. and generated
AS/400 native field names appearing wherever the SQL field names exceed
10 characters.

Is there a way to specify both the AS/400-native and SQL-native field
names when creating the file? And what about specifying an AS/400-native
filename when the SQL-native filename exceeds 10 characters?

I know about "LABEL ON" for column headings; I've used it in my own SQL
scripts

--
JHHL