We have recently switched to Oracle 9 from Oracle 8 and in this process the porting set was also upgraded to 7.1 d06.We came to know that this porting set works only in Level2.The data export from the existing server has been taken in Level2. how do i convert the tables to Level 2 from Level1. I was told by my seniors that bdbpre and bdbpost option could be used.how do i use it ? Can you help me on this?


I also get the error
Regards,
Query1

since you're oracle you could do something like

select 'alter table '||table_name||' drop column '||column_name||';'
from user_tab_columns where column_name like '%hash%';

select 'drop index '||index_name||';' from user_indexes;

Then create a gcommand script to re-create all of the indexes via
Baan.

as a matter of fact, that's pretty much exactly what I'd do...

Dave

<snip>
Then create a gcommand script to re-create all of the indexes via
Baan.
</snip>

Could you point me to docs on gcommand? Or basic syntax. I am looking at doing this conversion for Informix and L2.

Thanks,
Andy

There isn't any documentation... its a support/developer tool so they have all the info.. its unsupported and all that..

as for the syntax for creating indexes:

<file1>
#1 tccom000 TCRI 9999 -p 0

gcommand6.1 file1 <company>

that will create all of the indexes for tccom000

you could do a whole file of #1's with different tables, but
gcommand has a limited input buffer, so its better to do it in a
loop and send one line at a time.

Dave

#1 tccom000 TCRI 9999 -p 0

I ran this on development and worked great. Could explain the last parameters, I hate to run this on production without knowing what I am doing.

TCRI = create index command ?
9999 = ??
-p 0 = ??

Thanks,
Andy

Hi Andy - here's what I know off the top of my head...

#1 <table> TCRI 9999 -p 0
#1 = the db connection... so you could do #2 to open a new one.
TCRI = Create Index
9999 = Which index? (9999 = All)
-p = Print what I did to commlog
0 = I think this says "don't lock the table".. but I'm not sure.

Dave

Hi there,

Dave approach shows, how much insider knowhow he has. Not bad.

But actually, his approach should only be neccessary, if you use oracle exp/imp for the job.

If you use bdbpre/post (or the according baan sessions), then just dump the data with the old portingset and load them with the new. Baan will do the conversion automatically. Actually there is nothing to convert, because the dump does not contain the hashes etc.

Regards

Markus

Have a look here: gcommand tool (http://www.baanboard.com/node/53)

My way might be a little quicker in a level 1 -> level 2 conversion, since really you don't need to do the export/import.. but I think the easiest waywould be the pre/post method that Markus described..
I think actually, that I read the original post wrong
"bdbpre/bdbpost could be used" I read as "couldn't". Otherwise I wouldn't
have brought t up..

and I need to start looking at the wiki before I wrack my brains on
syntax!

Thanks!

Dave

Thank you all for the replies. We are looking at moving from L1 to L2 on Informix. While I agree that Baan tools are easier, I am looking for speed.

Andy