I have my DB2 database on mainframes and I am trying to replicate the same database on Windows server. I have loaded the table definitions to the Windows servers but looking for a way to export data from Mainframe DB2 tables to Windows server tables (Table definitions in both servers are same).I am looking for an easy and efficient way which can take care of nulls, strings, delimiters etc while exporting.Any help!
1. imagine there are 2 tables first table(personal table) consist of : name, age, official address, personal addresssecond table(address table) consist of : street, city, state, phone number, country, zip codeHere personal address and official points to address table1. create the above table2. find and goup the name of the person who lives in same zip code using personal addressIf somebody answer this, it would be a great help.
Will the ‘View’ get refreshed immediately when you update a database table. If it doesn’t get refreshed immediately, what method you use to refresh it ?
I have read somewhere as DDL statement as it has implicit commit statement.
Latest Answer: TRUNCATE is a DDL statement which can't be rolled back as there won't be any redolog generated during the trun operation and it is the fastest way of dropping big tables avoiding tons and tons of redolog generation. ...
Subform in ms access having data from linked table to sybase, gives odbc error.my data in of type text. Kindly throw some light. Thanks in advance. Karira, S.
Latest Answer: go to tool box ->click on mysqlDataAdapter->sql datadase is created-> sql.prompt-> click on ok button->in toolbox->windows-> datagrid->in properties of datagrid->data source & data member ...
Hello,I need some info, that is it possible to find or make query ,that if we know the data stored in a table but don't know the field name in which the required data is stored.ExampleTable having fields like columnA, columnB, columnC, columnD,..........columnN and all have the same dataType. and you dont know in which field your data exists.suppose some data like e.g. "BackMan" exists in any Field of the table but we don't know in which Field this information is store.Is
How to fetch old data with new database? suppose current inventory store in current database but after new year starting i want to store new year data in new database so howto fetch old data
How to maintain Big database During END of the Year????Example:My DataBase is Store and it has 40 tables..so after new year i want new transcation in new database.but Whats happen with my pandding data which is in old year ???this is My query
View page << Previous 6 7 8 9 [10] 11 12 Next >>
Go Top
