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!

Checking integrity of Macros.

Status
Not open for further replies.
CapsuleCorpJX

CapsuleCorpJX

IS-IT--Management
Jun 23, 2004
70
US
I noticed that Teradata SQL Assistant does not check the macros thoroughly enough.

It doesn't check to make sure that all the variables (WHERE ID = :VariableA for example) are declared in the parameter list. This has caused several errors on attempting to run the macro.

Is there some SQL Assistant setting or method to catch these errors during Macro storing?
 
Status
Not open for further replies.

Similar threads

Preshit
  • Locked
  • Question
Number of working days between two date fields
Replies
1
Views
156
johnherman
johnherman
ianbrown76
  • Locked
  • Question
Find ASCII code of characters in columns
Replies
0
Views
126
ianbrown76
ianbrown76
sajisher
  • Locked
  • Question
What is equivalent of oracle (+)= in Teradata
Replies
2
Views
56
sajisher
sajisher
JCV
  • Locked
  • Question
Date of last Table update
Replies
0
Views
59
JCV
JCV
neemi
  • Locked
  • Question
Getting List of all databases on server
Replies
1
Views
139
Gruuuu
Gruuuu

Part and Inventory Search

Sponsor

Back
Top