DSXchange

Hello, I want call a sql file that contain sql orders that create a table with indexes. i want do this , without routine, in the UDB API with the user defined DDL. Is it possible to call a file in this condition and how ? it seems that it's possible with oracle Thanks for your help Best regards, lud...

Thanks with the ";" character at the end of my SQL code works fine. But need to transform the output to have only the number of line. with this command call DSExecute ("TCL", "SELECT COUNT(*) FROM VOC WHERE F0 = 'DSU.FWKCommunRunOrJumpSavePointV2' ; " , Output, ReturnCode) output is equal to : COUNT...

The solution SELECT COUNT(*) FROM VOC WHERE F0 = 'DSU.FWKCommunLectureParam' can be a great solution. Works in the adminstator, but i want use it in a job control. I test this : call DSExecute ("TCL","SELECT COUNT(*) FROM VOC WHERE F0 = 'DSU.FWKCommunLectureParam' ", Output, ReturnCode) but if the '...

Hello, In a job control, i used the function DEFFUN to create a function based on a routine. But i have a problem with this when the routine no more exist or his name has changed : then the job control abort, when i run it, with an ununderstand error : Warning Attempting to Cleanup after ABORT raise...