SqlDbx Forum

SqlDbx

You are not logged in.

#1 2014-06-12 09:31:29

jhjdhfurzs
Member

DDL

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

#2 2014-06-12 15:12:10

sqldbxhelp
Administrator

Re: DDL

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

#3 2014-06-13 02:21:37

jhjdhfurzs
Member

Re: DDL

Yes, thats the problem, its all on a single line

Cheers,
Robert

Offline

#4 2014-06-13 09:18:50

sqldbxhelp
Administrator

Re: DDL

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

#5 2014-06-13 12:01:43

jhjdhfurzs
Member

Re: DDL

Sure, I will do that on monday.

Cheers
Robert

Offline

#6 2014-06-23 01:05:49

jhjdhfurzs
Member

Re: DDL

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

#7 2014-06-24 03:16:14

jhjdhfurzs
Member

Re: DDL

sqldbxhelp wrote:

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

#8 2014-06-24 06:22:02

sqldbxhelp
Administrator

Re: DDL

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

Board footer

Powered by FluxBB