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 Chriss Miller 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. ruse7013

    How to check batch file param number?

    Hello, What is the proper way to check for the number of command line parameters in Windows? In Unix there is something like: # If the number of command-line parameters # is not 10, then do something. if [[ $# -ne 10 ]] then ... fi How do we "translate" that into a Windows batch file code...
  2. ruse7013

    Fastest UPDATE of 1 Million Record Table

    Hi sem, Unfortunately, I'm under the gun to finish this task and don't have time to publish what you've asked me. The key here is - how we update the records in tab_A - one at a time or many at a time. Your idea is great, no doubt about that! Throughout the course of this discussion, both...
  3. ruse7013

    Fastest UPDATE of 1 Million Record Table

    Hi sem, Thank you for your idea. I tried it. The elapsed time does not look very promising - close to 10 minutes compared to my best of 224 seconds. I need to take another avenue. Thanks. Regards, <ruse7013>
  4. ruse7013

    Fastest UPDATE of 1 Million Record Table

    Hi sem, Yes, that's what my challenge is. If you take a look at my original message, it's all said there. Thanks, <ruse7013>
  5. ruse7013

    Fastest UPDATE of 1 Million Record Table

    Hi sem, In your suggestion above: UPDATE tab_A SET c1 = f1(c1,c2,c3), c2 = f2(c1,c2,c3), c3 = f3(c1,c2,c3) where is the "WHERE" clause? I guess, there should be one. Otherwise, how do we know that the update is done for a specific group of c1,c2,c3? In other words: UPDATE tab_A SET...
  6. ruse7013

    Fastest UPDATE of 1 Million Record Table

    Hi sem, The value conversion doesn't take too much time. So, I'll test your idea and see what happens. BTW, what's RBS? Thanks, <ruse7013>
  7. ruse7013

    Fastest UPDATE of 1 Million Record Table

    Hi sem, Please take a look at: ... processing of c1,c2,c3 ... getting new values of c1,c2,c3 c1,c2, and c3 are interdependent. A function is called w/ the old values as IN params. For every cursor iteration, ALL three old values are taken into account in order to determine what the...
  8. ruse7013

    Fastest UPDATE of 1 Million Record Table

    Hi Himanshu, I've done it. It didn't improve the elapsed time too much. However, I had a challenge of declaring the type of the bulk collection that would keep the ROWID values. Is this correct: TYPE typ_Rowid IS VARRAY(1000) OF VARCHAR2(50); I tried: TYPE typ_Rowid IS VARRAY(1000) OF...
  9. ruse7013

    Fastest UPDATE of 1 Million Record Table

    Environment: Oracle 8i (8.1.7) Scenario: Three columns are retrieved - CURSOR cur_name IS SELECT c1, c2, c3 FROM tab_A; Let's say the original retrieved values are equal to: c1=old_value1, c2=old_value2, c3=old_value3 Some processing take place and we find new values of c1, c2, and c3...
  10. ruse7013

    BULK COLLECT via DB LINK in Oracle8i

    Hello Himanshu, Actually, I found the init.ora as initSID.ora. However, I wouldn't be able to open it due to unsufficient access permissions. Also, I found this: "Consider increasing the value of the DISTRIBUTED_TRANSACTIONS when an instance regularly participates in numerous distributed...
  11. ruse7013

    BULK COLLECT via DB LINK in Oracle8i

    Hello Himanshu, I found file init.ora in $ORACLE_HOME/dbs However, there is not a parameter called distributed_transactions in file init.ora What can I advice my DBA as fas as setting that parameter? What's the best (or safe) value? Thank you. <ruse7013>
  12. ruse7013

    BULK COLLECT via DB LINK in Oracle8i

    Hello, Environment: Oracle8i Scenario: A package/procedure is executed under object owner "A" in db_schema "A". A cursor is retrieving records from a table "B1" from db_schema "B" (via a db_link!) using BULK COLLECT. Ultimately, all the records are INSERTed (via a db_link!) with FORALL INTO...
  13. ruse7013

    Subject: CURSOR and ROWID

    Sposibo, Dima! Regards, <ruse7013>
  14. ruse7013

    Subject: CURSOR and ROWID

    Hi Himanshu, You are right. I found the problem in the foo() function. It's related to: SELECT SYSDATE FROM DUAL; TWO records are returned instead of ONE: 5/5/2004 12:45:36 PM 5/5/2004 12:45:36 PM How can you explain that? I added: SELECT SYSDATE FROM DUAL WHERE ROWNUM = 1; ... but I...
  15. ruse7013

    Subject: CURSOR and ROWID

    Env: Oracle 8.1.7 The following procedure is executed: -------------------------------------- PROCEDURE proc_name AS CURSOR cur_name IS SELECT col1, col2, rowid FROM table_name; BEGIN FOR rec_name IN cur_name LOOP BEGIN v_var3 := foo(rec_name.col1, rec_name.col2)...
  16. ruse7013

    UNION, INTERSECT, OUTER JOINS, or INNER JOINS?

    Oracle DB version: 8.1.7 Scenario: --------- There are three tables A, B, and C. All of them have columns - c1, c2, and c3. Table A has about 30 million recods, table B - about 60 million records, and table C - about 1.5 million records. Question: --------- With one query, how can we...
  17. ruse7013

    FTP To Mainframe: Allocate file space via UNIT

    OS: AIX 4.3 Scenario: FTP from UNIX-AIX 4.3 to MVS I tried this: ftp> quote site lrecl=60 unit=DISK ucnt=5 blksize=27960 pri=1000 sec=500 cy ... but didn't work. Any idea? Thanks. <ruse7013>
  18. ruse7013

    FTP To Mainframe: Allocate file space via UNIT

    OS: AIX 4.3 Scenario: FTP a File to Mainframe. I want to allocate enough file space on the mainframe side with the UNIT parameter in the FTP command: ftp> quote site lrecl=$LRECL unit=$UNIT blksize=$BLKSIZE pri=$PRI sec=$SEC cy What are the options for $UNIT parameter? I need to specify...
  19. ruse7013

    Circular Record Reference

    The end of a sequence occurs when a SRC value (child) is equal to a DEST value (parent/ancestor), a.k.a. self-referencing. For instance, please take a look at my original example: Record #1 – For a specific ITEM (1111), DEST of “A” is a parent of a SRC of “B”. Therefore, SRC of “B” is a...
  20. ruse7013

    Circular Record Reference

    Hi lewisp, Thank you for your idea. The challenge has been resolved. It's a very short and "cute" solution. Regards, <ruse7013>

Part and Inventory Search

Back
Top