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!

  • Congratulations strongm 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. goodmans

    Win Server 2008: .bat to read and append/create new file files

    Hi, Platform: Win Server 08 Requirement is InputFile: File1 Contents: Row1: Col1_VALUE, Col2_Value, Col3_Value Row2: Col1_VALUE, Col2_Value, Col3_Value Row3: Col1_VALUE, Col2_Value, Col3_Value Row4: Col1_VALUE, Col2_Value, Col3_Value OutputFile: Loop No of rows in File1 (4) (...
  2. goodmans

    Migrating from vb6 to .net

    Any more suggessions? please.
  3. goodmans

    Migrating from vb6 to .net

    Ooops sorry. This code was developed in 2001, I have never touched it since then. I know RDO is pretty old, we know in 2001 it self we thought of moving to ADO. I definitely want to move to new connectivity libraries (ADOs). Now just wanted to start working on it. But to be honest say I like...
  4. goodmans

    Migrating from vb6 to .net

    Is VB6 still alive? is it worth moving to .Net?
  5. goodmans

    Migrating from vb6 to .net

    Hi VB Gurus, I have few applications that where developed in VB 6. its pretty old code which i have developed long back. We have a public module where we have code like this. Cn as rdoConnection Public Sub Main() Set Cn=en.openconnection(...) cn.open() End Sub We used the RDO library for...
  6. goodmans

    Convert into upper case

    Hi Informatica Gurus, I have source data in normal case. I want to load upper case into the target table. I know only the below synarios. Dont know if there is any other way to improve the performance. Flat File Source. 1. converting into upper case using the TR package. 2. Using expression...
  7. goodmans

    VB SCRIPTING IN EXCEL

    Hi, actually my search parameter changes dynamically. I cant use the pivot table wizards etc. I have to use this excel functionality with other tool, so i wont have option of wizards or manual intervention. So when data in search parameter cell changes. I want to dynamically populate the sheet3...
  8. goodmans

    VB SCRIPTING IN EXCEL

    I will pass the search parameter in the Main Worksheet of the same excel file. so it should get the parameter form Mainworksheet and do this work with in the excel file. Regards G
  9. goodmans

    VB SCRIPTING IN EXCEL

    Hi Guys, My source is Excel(.xls) file Worksheet1 COL1 COL2 COL3 US SALES 19 UK SALES 20 INDIA SALES 30 INDIA PUR 20 INDIA INV 50 CHINA SALES 15 IF I GIVE SEARCH PARAMETER AS "INDIA" IT SHOUD POPULATE THE Worksheet2 WITH INDIA DETAILS COL1 COL2 COL3 INDIA SALES 30 INDIA PUR...
  10. goodmans

    subquery in From Clause

    If i put the same subquery in the where clause it works.
  11. goodmans

    subquery in From Clause

    Yes it does. Its a simple query like select max(sal) from emp where ename like 'test%' Regards G
  12. goodmans

    subquery in From Clause

    Hi DB2 Gurus, I have a situation where i have to use the subquery in the from clause. But db2 is failing to execute the query. Below query working fine in oracle but its failing in DB2 v9. Dont know if its a known issue. please advise. SELECT dim.code, fact.amt FROM dim INNER JOIN fact ON...
  13. goodmans

    pickup source file

    Sorry i found the answer. Check the following option in the source definition properties. Add Currently Processed Flat File Name Port Thanks G
  14. goodmans

    pickup source file

    Hi Informatica gurus, Some one asked me a question like how can you pickup the source file name dynamically in the mapping with out using any unix scripting or paramfile etc. just using indirect file. Can someone answer me plz. Regards G
  15. goodmans

    Negative or positive number?

    I am going mad. if the number is lees than 0 its a negative number. Sorry guys. I am thinking too much. G
  16. goodmans

    Negative or positive number?

    Hi Infa Gurus. I have a input value coming through I just want to know if the number is positive or negative. Is there any informatica function which finds it out whether a given number is positive or neg? or do i have to use the same old logic of converting the value into char and check the...
  17. goodmans

    Exception Handling

    Sorry I am really confused now. I am simply asking for some code sample which handles any error, irrespective of what number it is. like we have error handling in oracle. Please let me know if this is possible in db2. Regards G
  18. goodmans

    Exception Handling

    Sorry for the confusion my main question is how to handle exceptions in DB2 like we have in Oracle. It doesnt have to be primary key dropping between begin and end block. let us take this example I want to create a constraint on a column but I dont know if that particular constrant already exist...
  19. goodmans

    Exception Handling

    This is for re-bulking the big volume of data, I want to drop all the constraints on the table before inserting bulk data. I got millions of data so I dont want to keep all the indexes. I can check for particular constraint name on a table if i know the constraint name, but these constraints are...
  20. goodmans

    Exception Handling

    Hello DB2 Gurus, I need a favour. How can I handle exceptions in DB2, I am very new to the db2. I know about exception handling. but dont know how I can do it in db2. I want to drop the primary key on a table. I dont want to fail the stored_proc if the primary key doesnt not exist. Oracle...

Part and Inventory Search

Back
Top