var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 commit and export question
1 How can I turn the auto commit off for the SQL I input. ( instead of
DB2 -c "update tablexxx set colxx=A"
2. I want to export data to a format without " " as delimiter, just BLANK,
How can I do that.
Thanks for advice.
a. Try setting db2set variable DB2OPTIONS to +c .
b. from CLP run this : update command options using c off
The later one did not work for me on NT. but the first method does.
Check the export command documentation, it specifies something known as chardel (character delimiter) which might be of interest to you.