Re: [EXTERNAL] How to change SQL table for field value

Hi,

Please see below screen shot:-
Specify CREATE TABLE Statement



Type information, press Enter.



File . . . . . . . . . . PFVEND4 Name

Library . . . . . . . SRCLIB Name, F4 for list



Nulls: 1=NULL, 2=NOT NULL, 3=NOT NULL WITH DEFAULT



Field FOR Field Type Length Scale
Null
VEND# NUMERIC 6
2
VENDNAME VENNAME CHAR 35
3
VENDADDR CHAR 50
3
VENDCAT CHAR 1
3

3

3



Botto
File CONSTRAINT . . . . . . . . . . . . . Y Y=Yes, N=No

Distributed File . . . . . . . . . . . . . N Y=Yes, N=No



F3=Exit F4=Prompt F5=Refresh F6=Insert line F10=Copy line

F11=Display more attributes F12=Cancel F14=Delete line F24=More keys


here while creating a table name using strsql in as400 there is a column
called FOR Field so suppose while creating this table let's say tab1 i
mentioned for field for vend# ABCDE and table is created successfully later
on i want to change this for field as shown in above screen shot how to
change that also how to retrieve the dds of this table like a physical file
in db2/400 we can make changes in dds and do CHGPF command to avoid data
loss after some DDS changes similarly i want to make changes in this for
fiels for above tab1 table which is created in sql400 using create table
command. any idea please?

1) How to retrieve the source created for sql table
2) How to make changes for this 'for field' which comes when we enter
create table and do f4(please refer above screen shot for more clarity on
this)

Thanks


On Wed, Feb 27, 2019 at 6:34 PM Alan Shore via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi Rishi
Not exactly too sure what you are asking
Could you give examples of what you need?

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf
Of Rishi Seth
Sent: Wednesday, February 27, 2019 7:41 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] How to change SQL table for field value

Hi,

While creating sql table suppose once we have created for field then after
create of sql table one wants to change this for field value then what is
the process for that?

Thanks
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com