Returning multiple recordsets from teradata database

[Megatronixs]

Hi all,

I have the below code to connect to a Teradata database and run an SQL statement to get a record set.
It works great, but I need to get data from different tables that are not related with eachother, but still are needed.
To get from 5 different record sets, I need to run 5 similar code like below, just the SQL will be different.

How could I re-use the below code to include 5 instead of one SQL request for record set without clossing the connection till all 5 did run?

Please Login or Register  to view this content.

Greetings.

[xladept]

You could use the GoSub...Return feature. Just list your 5 thissql assignments and evoke the GoSub to a procedure name such as "ProcessSql" you should have the procedure insulated with an Exit Sub - like this:

Please Login or Register  to view this content.

[Megatronixs]

Hi,

I tried it out, but get error: "Compile error: label not defined" on this line: GoSub PrcessSql

Any clue where it goes wrong?

Greetings.

(I'm using Excel 2003 at work and 2013 at home, maybe there could be a difference)

[xladept]

It may very well be the speling - PrcessSql v ProcessSql

It looks like it's my fault - sorry

Please Login or Register  to view this content.

And - thanks for the rep!

*You'll need to bump up your LastCol and LastCol2 before the return!

[Megatronixs]

Hi,

Thanks a lot :-)
I did not see it myself either, so, maybe it is my fault :-)

It works really great and I don't have to run separate macros to get the same done and then open the connections for each one and then close again.

Actually, my next step will be to tray to put the recordset inside a word document :-)

Greetings.

[xladept]

Hi Megatronixs,

I'm glad to hear that it works (that was sloppy work by me). Lot's of luck with WORD