Hello
Is [IF EXISTS] allowed in ALTER TABLE in DBISAM2
If not what is the easiest way to substitute ist?

Thanks for helping

HeiNi


>Is [IF EXISTS] allowed in ALTER TABLE in DBISAM2
>If not what is the easiest way to substitute ist?

I can't remember that far back, maybe someone else can but why not simply try it in DBSys.

If it isn't supported then with DBISAM's SQL I don't think you can do much (hopefully someone will prove me wrong). What exactly you can do will depend on what you're trying to do with it. One option, if you're wanting to use it to alter column definitions in an existing implementation would be to add code in the application to compare existing structure with desired struction and create the SQL for it on the fly, or just use table methods.

Roy Lambert

Hello Roy,

an error rises up. Yes it is to to alter column definitions in an existing table.

Roy Lambert wrote:

HeiNi


>Is [IF EXISTS] allowed in ALTER TABLE in DBISAM2
>If not what is the easiest way to substitute ist?

I can't remember that far back, maybe someone else can but why not simply try it in DBSys.

If it isn't supported then with DBISAM's SQL I don't think you can do much (hopefully someone will prove me wrong). What exactly you can do will depend on what you're trying to do with it. One option, if you're wanting to use it to alter column definitions in an existing implementation would be to add code in the application to compare existing structure with desired struction and create the SQL for it on the fly, or just use table methods.

Roy Lambert

HeiNi


In that case you need to write your own code unless you're lucky enough that someone has already done it and loaded it into the binaries. I seem to remember something in there.

There was also a third party tool I think from www.contextsoft.com, but you'll have to have a hunt round.

Roy Lambert

Thanks.