Is this the right way to execute a script in a sequence

[ady]

The script name is "PMCSExtractEPBWhlseOrders", its a sql script. I am specifying the script in a execute command stage in a sequence. Is this the way I am supposed to do it??

I get a error saying SP2-0640: Not connected, when i do it ... does this mean i dont have the permission to execute the script or , am i doin it wrong?

Please help

[chulett]

It should mean you left out the connection information. Are we talking Oracle here? Then your script needs to spawn a sqlplus session, supply the logon credentials it needs and then run your sql script. Would be pretty much identical for other databases except for the 'sqlplus' bit.

That's what any 'sql script' needs regardless of the tool launching it.

[kishoreramachandran]

please execute the script outside datastage first and check if it is working.
then what ever command you gave to execute, the same thing should be given from datastage.