Search results for query: *

Hi All, I have written a FAQ the subject below: create & drop index definitions generator faq179-4909 Please review and post your comments. I welcome any suggestion to improve it. Regards, Shriyan

Hi Folks, Here is a nice information related to Informix Backup & Recovery by W. Curtis Preston. The book is 1st Edition November 1999, pretty old though. http://www.oreilly.com/catalog/unixbr/chapter/ch14.html#30778 Regards, Shriyan "If you have knowledge, let others light their...

Hi, You may find the following information useful. Informix Database Utilities: Informix Load FAQ XPS Query Monitor Informix Disk Usage oncheck.awk for 7.x and 9.x disk usage for 8.x System Catalog Utilities: findcol depend.sh...

Hi 4GLers! Here in an interesting link, have look at: http://www.4glworks.com/4glworks.htm Regards, Shriyan "An ounce of example is worth a pound of advice."

Hi, A similar kind of data type is available, called SERIAL. You may specify the initial starting number as starting seed number (default 1) One need to pass a fixed value 0 for the serial type columns; so that the database server can generate to next sequence number in ascending order. If you...

hi, In a batch file I would like to get the input from the user. In Windows-98 for example following syntax works fine; but under Win-2000 it does not. choice /c:yn "Are you sure ?" Can anyone help me out? I would appreciate any suggestion. Thanks. Shriyan

We all know that only manipulation (DML) statements like insert,update and delete are logged in a database created with log facility. I would like to know why a sub-query involved SQL SELECT statement generates logical log data! Example: Test these commands in single user mode so that other...

Are you tired of typing dbaccess and selecting it's "ring menu" options for executing simple SQL statements? If your answer is yes, you may copy and paste the following unix script into a file and fire a SQL in a different manner. For example you may paste this script to a file called...

I want to add 'n' number of minutes to a datetime field. Following code works fine in 4GL. database rntdb MAIN DEFINE c_time DATETIME YEAR TO SECOND LET c_time="2002-07-28 23:40:40" DISPLAY c_time LET c_time=c_time + INTERVAL(46) MINUTE TO MINUTE DISPLAY c_time END...