I'm looking at porting an oracle app to teradata, so am using the Teradata 4.1 demo CD to determine if its possible and worthwile. I've have got as far as converting some of the simpler stored procedures, however I'm hitting a problem where I want to call one stored procedure from another, and it just seems to sit there not processing.
Basically, the stored procedure selects a set of keys from one table, loops through these calling the second stored procedure, which does several joins and ranks etc, and inserts the results from that select into another table. If I call the 2nd stored proc with 1 item, it executes fine (if a little slow - it takes about 8 mins, but it's only a mid-range desktop, so not really surprising). Calling the 1st stored proc, which would result in a set of about 400 keys in this test app, queryman just sits there, executing, but not generating any output rows, and having left it running all weekend, i would have expected something.
I'm guessing it might be a spool space problem, but don't know how to tell, as it says it is still executing, and doesn't throw any errors back.
Any help on how to find out what's going on appreciated..
Roy
Basically, the stored procedure selects a set of keys from one table, loops through these calling the second stored procedure, which does several joins and ranks etc, and inserts the results from that select into another table. If I call the 2nd stored proc with 1 item, it executes fine (if a little slow - it takes about 8 mins, but it's only a mid-range desktop, so not really surprising). Calling the 1st stored proc, which would result in a set of about 400 keys in this test app, queryman just sits there, executing, but not generating any output rows, and having left it running all weekend, i would have expected something.
I'm guessing it might be a spool space problem, but don't know how to tell, as it says it is still executing, and doesn't throw any errors back.
Any help on how to find out what's going on appreciated..
Roy