truncated DDL for view

[jmtorres]

HI, Running SAP IQ 15.4 Linux and Sybase Central. For some reason when trying to generate DDL from view they get truncated.( no more than 150 lines are generated) ,that is not of all the DDL definition for the view is generated. Is there any other way to do this?

Thanks

Regards

Jose

[tayeb_hadjou · Accepted solution]

Hi Jose,

If you are in IQ 15.4 ESD5 or upper, then you can use iqunload utility.

Example:

iqunload -n -c "eng=serv_iqdemo;uid=dba;pwd=sql"

iqunload Utility - For Schema and Data Export

http://help.sap.com/saphelp_iq1504_iqrb_aix/helpdata/en/2c/b96ad452fa4da6ad6ce9f9cbfca3

Regards,

Tayeb

[jmtorres]

Thanks again John

Regards

Jose

[john_ting]

no problem

regards

John

[jmtorres]

Tayeb,John

Thank you very much. It was an issue with one large view definition. We'll go ahead and use PD because we're on an EBF lower than ESD#5

One last question:

Could sp_iqview help as it sates in the manual:?

sp_iqview returns a view definition greater than 32K characters without truncation.

Thanks

Regards

Jose

[john_ting]

Jose

I think sp_iqview should work as well. or

you can    try to download the  following UNSUPPORTED scripts to extract DDL  and see if it helps. 

gvirtz-consulting.com/downloads.html

regards

John

[john_ting]

Jose

Another option is to use power designer to generate DDL.

Hope this helps

regards

John