I have one export query has been modified and now it exports in LONG VARCHAR format. Previously it did not and it just fit to the data table length. How can I adjust it back to fit as the data is?
The message I get during the export is
"Exported data includes LONG VARCHAR, LONG VARBINARY, and/or JAVA OBJECT columns. A width of 32768 bytes/characters will be assumed for these columns."
The below is the script:
However if I go to DBISQL and output the specific function: replace((substring(micros.dly_srv_prd_trk_ttl.trk_cnt_62,1,9)),' ','')
It is exporting in a nice way where the data size is fit to the number instead of 32768 characters.
You can use the builtin exprtype function to find out what data type is generated for a particular column in a result set. Starting with v10, you can also use the sa_describe_query system procedure to find out about the data type (and much more) of each column of a result set.
Note: You will have to mask any single quote within your query as these functions/procedures require the complete statement as a string, so double all single quotes...
After you have find out what expression returns an undesired data type, you can certainly cast that to a fitting data type, such as