Is declare table necessary in DCLGEN

chandhanarao · New User Joined: 04 Jul 2007 Posts: 4 Location: chennai

is declare table necessary in DCLGEN?

socker_dad · Posted: Sat Jul 28, 2007 12:08 am

As far as I know, if you want to use the data in a program, that's a big Yes!

Not sure about SPUFI, however.

chandhanarao · New User Joined: 04 Jul 2007 Posts: 4 Location: chennai

But , as far as i found out..... Declare table is not necessary in DCLGEN, that is used by the precompiler to check if the column names are correct. So if we have perfect idea of the column names we can hard code it in the W-S Section. It is used in order to avoid errors

Suryanarayana.tadala · New User Joined: 03 Nov 2005 Posts: 43 Location: St.Louis

No Need as DCLGEN is a copybook version on the table definition..

Thanks

Bhagyalakshmi C · New User Joined: 24 Jul 2007 Posts: 38 Location: Bangalore

Hi,

I have a table i dont know any thing about the table.. i can jus see the records in the table using the comand select * from table name..
i need to write the table contents into a file.
how it can be done and in what way the DCLGEN can be used.
Help me!!!!!!!!

Thanks all!!!!!!!!

ksk · Posted: Fri Aug 03, 2007 3:21 pm

Hi,

DCLGEN is Declarations Generator which is used to create the host language copy books for the table definitions. From DCLGEN, you will come to know the coloumns of the table (with minor differences, Hyphens and Underscores).

Retreive all colomn values into host variables and move these fields into the file variables.

For eg:

Select col_1,col_2,col_3 (Table Fields)
into :col-1,:col-2,:col-3 (DCLGEN Fields)
from COLTAB

MOVE COL-1 of DCLGEN TO FIELD-NAME of FILE.
MOVE ............
MOVE .............

Please correct me if I am wrong.

Regards,
ksk