on 05-17-2016 3:27 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks again John
Regards
Jose
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jose
Another option is to use power designer to generate DDL.
Hope this helps
regards
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.