Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Procedure return error code to BTEQ.

Status
Not open for further replies.
CapsuleCorpJX

CapsuleCorpJX

IS-IT--Management
Jun 23, 2004
70
US
A kornshell script uses BTEQ to call a SQL Stored Procedure on teradata.

My question is how can I get my SQL procedure to return an error code to BTEQ?

I want the SQL procedure to be able to signal BTEQ, and have BTEQ signal the ksh script to exit with an abnormal status so it will halt subsequent jobs in the schedule.
 
Status
Not open for further replies.

Similar threads

Teamalone
  • Locked
  • Question
How to export multiple files using teradata tpt
Replies
0
Views
179
Teamalone
Teamalone
Samm2020
  • Locked
  • Question
Oracle to Teradata for data source setup
Replies
1
Views
153
johnherman
johnherman
multipledatabases
  • Locked
  • Question
How to bulk import a CSV or a TXT file trough command into a Teradata database
Replies
1
Views
293
Miguel93
Miguel93
btrini
  • Locked
  • Question
Error 3544: Partial string matching requires character operands
Replies
0
Views
220
btrini
btrini
tmcrouse
  • Locked
  • Question
tough time with a teradata date format
Replies
0
Views
137
tmcrouse
tmcrouse

Part and Inventory Search

Sponsor

Back
Top