ACCESS bites again!

[novaphl]

hi DB2 guys.<br>
I am an Access moving to DB2 small company DBA. <br>
How come every time when I want to modify a table(modify column name, column data type , etc) I can't?<br>
I liked Access because it was so accessible but now we are moving to DB2. Is there something wrong that I doing?<br>
Thanks,<br>
Kyle

 

[amosgreg]

Make sure you take the time to read the manual on the DB2UDB. What you want to use is the ALTER TABLE command.<br>
This is assuming you have the proper authority to do so.<br>
Make sure you have also set up your log-on at an Administrator level.<br>
<br>
Also there is a great DB2 On-Line Library accessable from <A HREF="

http://WWW.IBM.COM"

TARGET="_new">

http://WWW.IBM.COM</A>

I don't have the exact link with me but that should get you started.<br>
<br>
DB2 UDB is a lot more complicated that Access but that much more powerful once you begin to understand it.<br>
Good Luck Greg<br>

 

[novaphl]

Hi there,<br>
Thanks for responding!<br>
I talked to IBM support and they confirmed that I cannot change field datatype or field name using the ALTER TABLE feature. Is there something that the IBM support guy missed?<br>
If so, please let me know! I am logging in using the admin account into an DB2 for WinNT (4.0 Server).<br>
Thanks again! <br>

 

[amosgreg]

Another approach would be to import the table from access,<br>
Create a table in thhe format you want and write a conversion script to move the values from on table to another with the length and format changes you require.<br>
Yes this is a fair amount of work but it also prepares you for future Data Conversion efforts as then only the script needs to be changed.