rleinen

Execute SQL using PSOS does not always work

Discussion created by rleinen on Nov 20, 2017
Latest reply on Nov 21, 2017 by rleinen

The following lines work great when script is called using Perform Script:

 

(A) Execute SQL [ With Dialog:off; ODBC Data Source: zzz; Calculated SQL Text: "Exec [ts].[startup_timesheet] 1]

(B) Execute SQL [ With Dialog:off; ODBC Data Source: zzz; Calculated SQL Text: "Exec [ts].[set_Week] 1, 100]

 

When using PSOS this first one works:

(A) Execute SQL [ With Dialog:off; ODBC Data Source: zzz; Calculated SQL Text: "Exec [ts].[startup_timesheet] 1]

 

And the 2nd one never executes

(B) Execute SQL [ With Dialog:off; ODBC Data Source: zzz; Calculated SQL Text: "Exec [ts].[set_Week] 1, 100]

 

Any ideas how to troubleshoot this?

Outcomes