| View previous topic :: View next topic |
| Author |
Message |
sunilchik
Beginner
Joined: 08 May 2003
Posts: 11
Topics: 4
|
 Posted: Tue Nov 04, 2003 2:22 am Post subject: Error -904 |
 |
|
Hi,
I am running DB2 on MVS os.
I have a simple query like this
| Code: | SELECT COUNT(DISTINCT(CLIENT_ID))
INTO :WS-COUNT
FROM U_BAS_V |
There are around 250 tables and for each table such a query.
Problem is when I am running the execute JCL the first query runs but it gives a -904 for the second table and so on. Each time I run the JCL it runs for one or two table and gives error -904 in third. So what |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Tue Nov 04, 2003 6:20 am Post subject: |
|
|
sunilchik,
Try this
| Code: |
SELECT COUNT(DISTINCT(CLIENT_ID))
INTO :WS-COUNT
FROM U_BAS_V
WITH UR
|
|
|
| Back to top |
|
|
sunilchik
Beginner
Joined: 08 May 2003
Posts: 11
Topics: 4
|
| Posted: Tue Nov 04, 2003 7:03 am Post subject: |
|
|
Hi Kolusu,
Thank you for your prompt response Kolusu..
I tried it earlier.
It was not helping.... |
|
| Back to top |
|
|
sunilchik
Beginner
Joined: 08 May 2003
Posts: 11
Topics: 4
|
| Posted: Thu Nov 06, 2003 7:08 am Post subject: |
|
|
Hi Guys,
I am done with it. The problem was with migrated indexes.
I got a jcl from sys admin which recalled all index related datasets.
Now its running in a flash of a sec.
Jcl is given
//JS10 EXEC PGM=IKJEFT01,DYNAMNBR=1024,REGION=0M
//SYSTSPRT DD SYSOUT=$
//SYSUDUMP DD SYSOUT=$
//SYSTSIN DD *
HRECALL 'DB5VV.DSNDBC.XCCLDUT.CLB*.**'
/*
//
Thx a lot for all your efforts. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
