Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vpshriyan

    [Informix][Informix ODBC Driver]Function sequence error.

    Please refer to below link; you may get some insight http://wiki.ispirer.com/sqlways/troubleshooting-guide/informix/export-conversion/data/function-sequence-error
  2. vpshriyan

    ODBC Connection Error

    The error sounds like you have ended up with glitches in some indexes. Consider running onchecks to confirm that there is a problem with an index. Try oncheck -- which will show more detail for the command. Once you have identified a problem sourced index, drop and recreate it.
  3. vpshriyan

    Declaring cursors in Informix 4gl

    The data you fetch from disk is stored and controlled in server's limited shared memory. In single go entire data scope is not populated into shared memory but based on amount of free shared memory available, the online manages to store retrieved data. It is a best coding practice to use...
  4. vpshriyan

    database level priveleges

    Get every user defined table names in a database use SQL below: select tabname from systables where tabid > 99; Please note that to set the access granularity you may have to revoke access given to the object "public" if any, for each table. eg. revoke all on "owner".table_x from "public";
  5. vpshriyan

    DBimport new help

    Have you tried dbload?
  6. vpshriyan

    How to get list of changes to the tables/structure

    This kind of history data is not stored in any part of the metadata. The current info can be pulled from the SQL below: select tabname ||' '|| created from systables where tabid>99 ;
  7. vpshriyan

    tempdbs

    It looks temp sort space is going out of space. Introduce the environment variable PSORT_DBTEMP to place sort files. export PSORT_DBTEMP=/tmp to place it on alternate locations try this: export PSORT_DBTEMP=/tmp:/tmp2
  8. vpshriyan

    Unload command

    1. delimiter "" removes the default pipe data delimiter If it fails try to use || (concat) Unload to c:\junk\test.txt select field1|| field2|| field3 from file1 ; 2. unload statement knocks off spaces in the data. Use nvl function to fill the place holders. Unload to c:\junk\test.txt select...
  9. vpshriyan

    can not kill a session using onmode -z (pid)

    Just to make sure... onmode -z <sid> ie. session id and not <pid> May be a transaction is in progress in the sid in question. You may try to end it by: xsid=`onstat -u | grep <sid> | awk '{print $1}'` onmode -Z $xsid onmode -z <sid>
  10. vpshriyan

    ODBC erro

    Is the finderr -208 explanation helps?
  11. vpshriyan

    dbexport

    This sounds strange! Do you have dual login? If so, in one of the login, DBDATE may not have been set to British format.
  12. vpshriyan

    Varchar/delimiter problem

    You may use: sed 's/^M//g' input_file > output_file Note: ^M is Ctrl+v Ctrl+m
  13. vpshriyan

    ODBC .NET &amp; Informix

    Dan, not very sure but it looks some access componants are missing at local setup. Have you installed/updated your MDAC (Microsoft Data Access Componants)? If not go to the Microsoft website and do a search on MDAC.
  14. vpshriyan

    dbimport - tables in specific dbspaces

    Jack, if you have preserved all data of your earlier dbexport, you may edit your <database>.sql file. In all the "create table" and "create index" tables suffix "in <space_name>" syntax. Once you have completed this, drop the database and import the data afresh to multiple dbspaces. In the...
  15. vpshriyan

    ISA connecting to a not very certain informix installation

    The ISA installation program adds environment variables (INFORMIXSERVER, INFORMIXDIR, ONCONFIG ) to the isadir/etc/isacfg file. Review it for its correctness. One more point - You must start the ISA Apache HTTP server before you can access ISA. To start the server manually as user informix, run...
  16. vpshriyan

    Removing old databases

    1. Direct the output of the statement to file1.sql unload to file1.sql select name from sysmaster:sysdatabases where name not in ('sysmaster','sysutils','sysusers'); 2. Prefix drop syntax sed 's/^/drop database /' file1.sql > file2.sql 3. Substitute | with ; sed 's/|$/;/' file2.sql...
  17. vpshriyan

    ISA connecting to a not very certain informix installation

    slightly on off-subject: "oninit: Fatal error in shared memory creation" message is due to execution of oninit command while dbserver instance is already initilized in the shared memory. To ascertain if shared memory initialization has any issues, first do a complete shutdown by onmode -uky and...
  18. vpshriyan

    ISA connecting to a not very certain informix installation

    IDS configuration seems to be OK for a test box. Post outputs of commands below: 1. onstat -g dis 2. grep informix_lop /etc/services
  19. vpshriyan

    DDRBLOCK problems

    A case where dbserver nearer to overwrting a LL (logical log) that ER (Enterprise Replication) has not yet processed is called DDRBLOCK mode. Hence you get to see this message. Refer Chapter 9-14 of IBM Informix Dynamic Server Enterprise Replication Guide for more details. PDF Book Link...
  20. vpshriyan

    UPDATE STATISTICS

    Hi, When statistics are updated with low keyword, information is not updated at sysdistrib table, hence no traces of timestamp is available. Keywords medium and high will generate columnwise data bins in distrib table. Following SQL statement will show when & how the last update statistics...

Part and Inventory Search

Back
Top