User Profile

pramodds · Feb 14 '11, 01:07 PM

Please paste the load command being used. Will check in my local setup and try to get back with solution

pramodds · Feb 5 '11, 04:22 PM

Hi,

try this in this format, it could work.

IMPORT from /appldata/dwins25p/cryr3_1/DART0002/TS1116T2.IXF,
/appldata/dwins25p/cryr3_1/DART0003/TS1116T2.IXF,
/appldata/dwins25p/cryr3_1/DART0004/TS1116T2.IXF,
/appldata/dwins25p/cryr3_1/DART0005/TS1116T2.IXF
of IXF Method P (1,2,3,4,5,6,7, 8,9,10) messages ....and so on.

We usually give multiple Input files for...

pramodds · Feb 5 '11, 11:29 AM

Try this

select \"co_code\" from BSE500DTA.STK_P RICE_RAW_DTA fetch first 100 rows only

Try to give the cloumn name from this o/p

db2 describe table <tabschema>.<ta bname>
whatever is the o/p for "column co_code" use that exactly in the above statement.

Cheers
Pramod

pramodds · Feb 5 '11, 08:39 AM

There are lot of online DB2 links for detailed information of online and offline reorgs. Suggest to look at DB2 Infocenter for release V9 or V9.5.

pramodds · Feb 5 '11, 08:36 AM

Hi,

I would suggest to use interactive tool - db2haicu
Just type "db2haicu", you will get lot of interactive options and in the final phase of this interactive configuration it will ask for vaildate and automate databases and that time you can give each & every db name separately. I think this will also work if you have already done setup for one DB with XML cfg and you want to add another 5 Databases, then just type...

pramodds · Feb 5 '11, 07:08 AM

As said before,u can use this
db2 list tables for schema <schema name>
or
query syscat tables.
db2 "select tabname from syscat.tables where tabschem='<sche maname>'"

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Why is SQL stored procedure taking long time to complete?