DSXchange

If they are in the same schema then you can probably join several keys while building your hashed file. Lets take your current situation. Build your hashed file with the following query from the database. SELECT N.nationkey, R.regionkey, <Rest of the columns that you need in your hashed file> FROM n...

I missed the ODBC part in the error message. Calling a stored procedure from odbc can only support IN and IN/OUT parameters. It does not support OUT or RETURN parameters.

Welcome Aboard
Does the stored procedure run from command line or your favourite sql tool?

You are replying to a post that was last answered in Jun 06.

You are right Craig. It wont work without preceding it with '-param'. I just missed that
I fixed my previous post.

You can certainly do that. But you got the sytax wrong. Heres the correct syntax

beaditya wrote:Can I just create a server job to write the fixed width data into another normal seq file and then get it into parallel? Will that work ?

I never used HEX, so thats gonna be a problem

Good idea. Sounds good.

Look into the Modify Stage pdf help. There is a chart of all the conversion functions. From the error message it seems that sucha function doesnt exist. Dont have access to DS right now. If its not there, then use the function us1aslam1us advised.

us1aslam1us, some spaces are fine. They just mean that there is no value. Spaces within fields are ok, but the OP has to validate that and make sure that these spaces are the 'OK' spaces.

Your schema is messed up. Analyze it with me, if you will. Lets take your first record and break it up to your schema. The length of the column is in brackets. 0501025414 (10) 638979 (6) P+ (2) 4 (1) (1) 2005-02-01 (10) (1) (4) 0 -12 &#...

The first record of your sample data is of length 54 (including all spaces). If you add up the length's in your meta data, its 61. Your meta data is wrong, or your file is wrong. At a glance, a person can tell that, for a fixed width file, its not formatted correct. Go back to your post and enclose ...

See if this post helps. Ray mentioned a few conversion functions in that post. You can take a look at that.

Can i see a sample record, maybe a few records and the meta data that you defined. I suspect your lengths are not correct.

All you need to specify is Under format tab - Record Level --> Record length = fixed Record Delimiter = UNIX newline - Field defaults --> Delimiter = none. Then go to the Columns tab and specify all the columns as 'char' type and specify the correct length. That is it.