MVSFORUMS.com

[Ranjish]

Hi,

I did some search for the question, but did not find correct information.

Our requirement is to download from a partitioned table space.

The query is like this...

SELECT field1 FROM table1 PART 1,
table2
WHERE
field2 = field2 ;

Here field2 is there in table1 and table2. So we want to give synonym for the tables.

How can we give the synonym in this case?

I tried giving like

SELECT field1 FROM table1 A PART 1,
table2 B
WHERE
A.field2 = B.field2 ;

This gave an error

FU030 - DATA FIELD NOT NUMERIC OR OUT OF RANGE - CHECK DOCUMENTATION

FU075 - INVALID SELECT STATEMENT - SEE DOCUMENTATION

Thanks,
Ranjish

[kolusu]

Ranjish,

It would have been easier if you had mentioned the utility you are using to unload the data. I had search around and finally figured that you are using CA-FAST UNLOAD.

I guess the sql-access is the culprit once again. If SQL-ACCESS NONE is specified, the view cannot have any of the following in the view definition:

• Joins
  
• DISTINCT clauses
  
• Column functions
  
• Scalar functions
  
• WHERE clauses
  
• ORDER BY clauses
  
• HAVING clauses
  

If any of the above is specified in the view definition, SQL-ACCESS must be specified as ONLY or EXTENSION, so that Unicenter Fast Unload can use SQL access to unload the table data.

So check your unload control cards and specify the sql-access to only or extension and you should be able to unload the data.

Check this topic which discusses sql-access which accidentally is started by you.

http://www.mvsforums.com/helpboards/viewtopic.php?t=1972&highlight=sqlaccess

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[Ranjish]

Hi Kolusu,

Thanks for your reply and sorry for not mentioning the utility in my original post.

I checked the utility control card and it is using SQL ACCESS EXTENSION.

The following is the control card which I am using.

FU003 - FASTUNLOAD CONTROL CARD PARSING STARTED - U01E1 - 12/27/02
FASTUNLOAD
EXCP YES
INPUT-FORMAT TABLE
IO-BUFFERS 60
LOAD-CONTROL DB2LOAD
VSAM-BUFFERS 360
DISPLAY-STATUS 100000
SHRLEVEL CHANGE,BP-LOOKUP
SQL-ACCESS EXTENSION
SORTDEVT SORTWK SORTNUM 4 ESTIMATED-ROWS 1000000
OUTPUT-FORMAT DSNTIAUL

regards
Ranjish

[kolusu]

Ranjish,

Try the following control cards and see if it works.