SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 06:03 AM
| |||
| |||
 Re: DB2 UDB Help "Randy" <gastcom@sympatico.ca> wrote in message news:zg4Hf.5107$J%6.352333@news20.bellglobal.com.. . >I am new to DB2 > > I am converting an Oracle database to UDB. > There is a procedure that builds and writes ( line by line, manually ) > delimited rows to a file. > > Can I do this in DB2 ? Look at the export command in the Command Reference. This can invoked from a stored procedure (there is a special function to do this).      |
|
02-27-2008, 06:03 AM
| |||
| |||
| Re: DB2 UDB Help Thanx Mark, I am building a table out of columns from others. I can't test with views because my dba's don't get it  So it's cursor time ... ahaha.I will try build a temp table and exporting. What do the cool kids use for writing DB2 SP's ? I downloaded Toad, the price is right. Randy "Mark A" <nobody@nowhere.com> wrote in message news:MuKdnSZDq4KJS3HeRVn-rA@comcast.com... > "Randy" <gastcom@sympatico.ca> wrote in message > news:zg4Hf.5107$J%6.352333@news20.bellglobal.com.. . >>I am new to DB2 >> >> I am converting an Oracle database to UDB. >> There is a procedure that builds and writes ( line by line, manually ) >> delimited rows to a file. >> >> Can I do this in DB2 ? > Look at the export command in the Command Reference. This can invoked from > a stored procedure (there is a special function to do this). > |
|
02-27-2008, 06:03 AM
| |||
| |||
| Re: DB2 UDB Help Randy wrote: > Thanx Mark, > > I am building a table out of columns from others. I can't test with views > because my dba's don't get it So it's cursor time ... ahaha.> > I will try build a temp table and exporting. > > What do the cool kids use for writing DB2 SP's ? I downloaded Toad, the > price is right. > The procedure Mark refers to is called SYSPROC.ADMIN_CMD(). It was introduced in FP9. DB2 V8.2.2. You can use development center (free, comes with DB2), TOAD or Rational Application Developer. I don't recall whether TOAD supports SQL Procedure debugging.... Come to think of it I use Ultra Edit :-) Cheers Serge -- Serge Rielau DB2 Solutions Development DB2 UDB for Linux, Unix, Windows IBM Toronto Lab |
|
02-27-2008, 06:03 AM
| |||
| |||
| Re: DB2 UDB Help Randy: To convert each and every table from ORACLE to UDB with all this data conversions is very time consuming. What i did in my project is Setup a Federation between UDB to ORACLE and exported the data from ORACLE (from NICKNAMES) and Loaded into UDB database. Very fast and no need to worry about all these conversions...etc regards Shashi Mannepalli Randy wrote: > I am new to DB2 > > I am converting an Oracle database to UDB. > There is a procedure that builds and writes ( line by line, manually ) > delimited rows to a file. > > Can I do this in DB2 ? |
|
02-27-2008, 06:03 AM
| |||
| |||
| Re: DB2 UDB Help If there is large volume of data in Oracle to be converted, I can suggest using Fastreader from wisdomforce. fastreader will extract export data from Oracle into ascii text files and will create input for DB2 loader. Fastreader could be found at www.wisdomforce.com > Randy wrote: > > I am new to DB2 > > > > I am converting an Oracle database to UDB. > > There is a procedure that builds and writes ( line by line, manually ) > > delimited rows to a file. > > > > Can I do this in DB2 ? |
|
02-27-2008, 06:18 AM
| ||||
| ||||
| Re: DB2 UDB Help Randy wrote: > I am new to DB2 > > I am converting an Oracle database to UDB. > There is a procedure that builds and writes ( line by line, manually ) > delimited rows to a file. > > Can I do this in DB2 ? > > There is also a free DB2 Migration Toolkit that will handle Oracle to UDB migrations. I have used the SQLServer toolkit with much success. www.ibm.com/software/data/db2/migration/mtk Mike |
Linear Mode
