SqlDbx
You are not logged in.
Hi, DDL is not formatted correctly as the whole DDL is displayed in a single row. There seems to be a difference between CRLF and LF in Requesttext.
Cheers,
Robert
Offline
I cannot reproduce it.
Do you see one line when you right click and select "Script Create"?
Was DDL executed in SqlDbx or using something else?
Offline
Yes, thats the problem, its all on a single line
Cheers,
Robert
Offline
Can you please run the query below with example of the object having this issue and email it to support.
SELECT CHAR2HEXINT (RequestText) FROM DBC.tables
WHERE DatabaseName = 'your_database' AND TableName = 'your_object'
Offline
Sure, I will do that on monday.
Cheers
Robert
Offline
Using the RequestText from DBC is not a good idea, cause if a table has been created like: CREATE TABLE X FROM TABLE Y WITH DATA ... this will be the Requesttext. You should use SHOW TABLE, SHOW VIEW, SHOW MACRO aso for retrievin Object Definitions.
Robert
Offline
Can you please run the query below with example of the object having this issue and email it to support.
SELECT CHAR2HEXINT (RequestText) FROM DBC.tables
WHERE DatabaseName = 'your_database' AND TableName = 'your_object'
Result:
0043005200450041005400450020005400410042004C004500200044005F004100550054005F004D0053005F004500320045005F005200450050002E005400420044005F004500780063006C007500730069006F006E00200041005300200050005F004100550054005F004D0053005F004500320045005F005200450050002E005400420044005F004500780063006C007500730069006F006E002000570049005400480020004400410054004100200041004E004400200053005400410054004900530054004900430053
Offline
There's no line breaks in text above. It would be better if you can provide text for procedure or macro.
We do not use RequestText for scripting.
Offline