Search results for query: *

:) Thanks so much.... I finally got it to work. I needed both the foldline and the sidetitles as you indicated. What was strange... when I executed the stored procedure from BTEQ it let me name the Out parameters with a title ''. When I ran it from queryman it would not let me do that...

Thanks... That worked when I defined the first 3 Out parms as length 36... The problem is that I have 27 out parameters which I have declared at char(256) each (I am generating SQL). I would like to have each select "column" item put on a separate line in the output. With the limits...

I have created a Stored procedure which Select V1, V2, V3 ... into Out1, Out2, Out3. I then call the stored procedure from BTEQ passing all the parms and .EXPORT REPORT DDNAME = OUTFILE. When I look at the OUTFILE I only see the results for the Select of V1 (Out1 parameter). How do I get V2...

Thanks for your great answer. Now that I think about it the labels are for the out parameters and not the columns. That explains why the (Title '') doesn't work. I don't know why I can't give the out parms a name of '' in the call stmt. Do you know of a way to execute the SQL stmts that I...

I am generating SQL in a stored procedure (On Teradata Release V2R.04.00.03.03 so I can't execute it dynamically). I want to have the output not show the column names. I tried putting (TITLE '') after each SQL statement, but it doesn't have any affect. Then I tried to use cast(stmt1 as title...