• log writing timestamp

    October 25, 2004

    Db2 writes timestamp of each sql statement being run, when writing in the log files. and the log files are not in human readable form. lets say today is 26th and tomorrow will be 27th, if I change the date to tomorrow and run some insert, delete, update sql stmts, and then change the date […]

  • log wrirting

    October 25, 2004

    When writing into the log file, does db2 write the timestamp of when the sql stmt is also run on a database?

  • views question

    October 25, 2004

    1) create a table with 2 columns 2) create a view with select * from the previous table 3) Insert couple of rows into the table 4) alter the table and add a new column to it (making the total column count 3) 5) insert one more row such that it has 3 cols now […]

  • PERL question

    October 6, 2004

    I am trying to redirect the output of a command to a file, but it says there is no database connection. ————— `db2 connect to example1`; `db2 “select * from jobs” > jobs.txt`; print `cat jobs.txt`; ————— I dont understand y this fails. I could the same result using open file stmt, but I wonder […]

  • Books and Tutorial

    October 6, 2004

    Hey guys, my first message on BLOGS. This seems to be a cool website for us. Check it out. http://www.dhruvaraj.com/Database/main.htm Regards Naveen.

  • Net Search Extender

    October 4, 2004

    Intro: DB2 Net Search Extender Version 8.1 is one of a family of DB2 Extenders™. It replaces DB2 Text Information Extender Version 7.2, and Net Search Extender Version 7.2 and offers users and application programmers a fast, versatile, and intelligent method of searching full-text documents stored in DB2, other databases, and file systems using SQL […]

Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org