Beginner SQL script

[Guest_imported]

Can I use regular programming commands such as "if then" statements in sql scripts within UNIX?

Here is some psuedo code to what I need to do:
SCRIPT>
If tablename.businessunit = '1'
execute "procedure1"

If tablename.businessunit = '2'
execute "procedure2"


"procedure1" is a script that selects certain fields and writes to a flat file

 

[vgersh99]

I thought the name of this forum was "UNIX Scripting"...

You might be better off asking this question at some kind of the DB/SQL forum......

 

[olded]

Mcgusto:

You might also tell us what database vendor you're using. SQL scripts, generally, aren't all that portable between informix, oracle, SQL server, etc.

Regards,


Ed

 

[KarveR]

mySQL forum is here: forum436 ***************************************
Party on, dudes!

 

[oracle42]

Wrong forum, but nevertheless, think about using pl/sql(Oracle only) or C-embedded sql