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!

Recent content by mpcurry

  1. mpcurry

    parameter file

    Try using : -paramfile $PM_PARAM_DIR/$PARAMETER_FILE as argument to pmcmd command.Where $PM_PARAM_DIR is environment variable pointing to the directory of parameter file and $PARAMETER_FILE is environment variable for your parameter file name.
  2. mpcurry

    Feed structure validation

    Hi vln, What if it is not a valid number and I want to reject that record with an error message in the session log. Regards.
  3. mpcurry

    autosys scheduler

    Yes, Autosys can be used for the same by using file watchers in the Autosys. I won't be able to provide you more details on this but it is possible using Autosys.
  4. mpcurry

    lookup returns multiple rows

    Yes you are right, we won't be able to implement this. By same I meant that my query is also doing the same thing : 1) It creates three fields (website,size and place) on the basis of value in the value field. 2) Perform the aggregation using MAX function. Regards
  5. mpcurry

    lookup returns multiple rows

    Forget it..Its difficult to implment and moreover it is exaclty the same as suggested by T.Blom.
  6. mpcurry

    lookup returns multiple rows

    Hi, I'm new to informatica, but I think I can solve your problem by using SQL skills : 1) Take visit as your source table. 2) Amend your source qualifier to overide the sql with following : select visit_id, max(decode(name,'website',value,null))...
  7. mpcurry

    Cursors in Oracle

    I appreciate your comments to enhance the performance of my wrong(?) idea, I'm sure there will be several other ways to achieve this. But you have still not explained how my idea is wrong? I guess this will do the job (if not efficiently).
  8. mpcurry

    Cursors in Oracle

    Also, can I request you to explain your solution further as to how can we replace inner loop with update statement.
  9. mpcurry

    Cursors in Oracle

    I'm sorry Dima, Are you suggesting something new or is it an explaination to prove that above idea is COMPLETELY wrong.
  10. mpcurry

    Making My where Statement inside a Select branch!!

    Please try this : select a.orion_tank, b.OrionCrude, a.prop_modified_value, a.DayInserted, SEQ5_CRDINV.nextval, sysdate, user from ps_staging_data a, ps_crude_map b where a.Orion_tank = b.OrionTank and to_char(a.dayInserted,'dd/mm/yyyy') = to_char(sysdate, 'dd/mm/yyyy') and a.validated = 1 and...
  11. mpcurry

    Cursors in Oracle

    Can you please explain.....
  12. mpcurry

    Cursors in Oracle

    Hi Dima, I've quickly written something, by using FLAG variable, to exit from the outer loop, it might be wrong but I'm sure something of that sort can be done. Regards Ajay.
  13. mpcurry

    Cursors in Oracle

    COMMIT is after the inner end loop; Regards
  14. mpcurry

    Query Help

    Please use : SELECT ADJUSTER_NO, MAX(TRUNC(CASE_OPEN_DATE)) FROM AUTO_CLAIM GROUP BY ADJUSTER_NO By Using TRUNC, it will truncate the time stamp on all the dates. Regards Ajay.
  15. mpcurry

    Cursors in Oracle

    Hi Mike, Can I suggest you to create an extra column on your driving table say upd_flag and use this column to open your cursor like create or replace procedure SomeProcName as cursor SomeCurName is select awhole,bunchof,stuff from AReallyBigTable where...
See more

Part and Inventory Search

Back
Top