cancel
Showing results for 
Search instead for 
Did you mean: 

truncated DDL for view

jmtorres
Active Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

tayeb_hadjou
Contributor
0 Kudos

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

Answers (3)

Answers (3)

jmtorres
Active Participant
0 Kudos

Thanks again John

Regards

Jose

john_ting
Explorer
0 Kudos

no problem

regards

John

jmtorres
Active Participant
0 Kudos

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
Explorer
0 Kudos

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
Explorer
0 Kudos

Jose

Another option is to use power designer to generate DDL.

Hope this helps

regards

John