DSXchange

I doubt there is a document for this manipulation per se, but you can make an educated guess. Add all the lengths up and add a few bytes to it. Ray has that info posted here somewhere. This will give you a good estimate of your row size. I also advise searching the archives, on keywords like "calcul...

You have to specify the default value within quotes.

Are you able to execute the stored proc. successfully and capture the OUT parameter from your favourite sql tool.

Read about stored procedure calls in ODBC help guide. I am pretty sure OUT parameter is not supported. But I can be wrong.

Another way that it can work is if you put the entire parameter name, equal sign and the parameter value within single quotes. I saw that in one of the top poster's scripts posted here. I have not tried it yet. You can give it a shot. Something like dsjob -run -wait -param 'DsName=Thomos E Edison' -...

Use the dssearch command. Something like

Search on dssearch in Server Job Developer's Guide.

What kind of variables are these? I think ODBC stage can only support IN and IN/OUT parameters for stored procedures. Do you have STP stage?

Put eval before dsjob.

Try giving '9999-12-31'

Preprocess the inputs and replace NULL values to a default value for comparison.

What did you find when you searched on "DSD.UVOpen mkdbfile: cannot create file" ?

Again it depends. Ask your DBA. Depending upon how heavily the database server is loaded and/or depending upon the temp space your DBA will give you and Ok or not. If the DBA agrees, nothing like it. You can pass your sql join and get the result for further processing. Else do it in datastage.

" " is not a DATE in any book. Provide a meaningful default such as 9999-12-31 or 1900-01-01 etc.

Click on the blue link (This) that I provided in my previous post. Basically for aggregation a dfloat is required. That link gives a step by step method by Kumar on how to get it done.

Large files require large tmp space. You can specify a temporary diretor using the -T option. Read about it in unix sort manual pages.