Recent content by myvision69

Export complete DB and Import into another Server Command I am looking to export complete database (DUMP) from one server and import into another from the export (DUMP) What is the command I can use to accomlish that? I do have the DB Admin User and Password. THANKS SO MUCH

is there a way to determine the average row length per table, number of rows and Row/Block/object overhead? get information about the object size =(Average row length per table * number of rows) + (Row/Block/Object overhead) Thanks

How can I send Print commands to USB Receipt printer to open Cash Drawer? Working with Ithaca 610 receipt printer and they told if you can send HEX value of 1B7801 it will open the drawer. How can I send hex value of 1B7801 to the USB printer? codes in other format are Decimal: 27 120...

Thanks for the quick response. I was hoping that I do not have to code each column with Left(). Is there a way to disable so it automatically takes only the part of the string that fits in the column width.

Is there a way to ignore "Message 8152 16 String or binary data would be truncated." so that the Update or Insert is successful even though string value is being truncated.

thanks for prompt reply. this only gives me active processes but i need to find what tables are locked up so I can troubleshoot the issue?

is there a way to find out what tables are locked and by what process? seems like there is an update somewhere with no commit causing all the users to lock up. THANKS FOR PROMPT REPLY.

i have a customer where one table is locked up for some reason and all access is serialized. how can i unlock the table and allow multiuser access? thanks

how can I import DB from oracle 8 DB dump file into oracle 9? Thanks

i have a date time column from which i only need to get the time portion hh:mm only and combine it with today's date into a datetime column. e.g. 01/01/2000 12:12:00 needs to be converted to getdate() + time from column = 04/12/2006 12:12:00 Thanks for prompt reply

I need to extract data from a Cobol program ans I have both the DTA and KEY files. Is there a way to convert the data into text file format? BIG THANKS

e.g. 78.00 needs to be displayed as 078 1.00 needs to be dispayed as 001 150.00 needs to be displayed as 150 How can I accomplish that?

i need to add a + sign if the value is greater than 0 in sql? how can i do that?

i have a decimal number stored but i want to display the whole number only with three digits and no decimal places. how can i do that in SQL? Thanks

When I open the Access 97 DB in Access 97 I get this error: 'C:\my.mdb' isn't an index in this table. Look in the Indexes collection of the TableDef object to determine the valid index names. How can I fix this be be able to see all the tables and data? Thanks for prompt reply.