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 Mike Lewis 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: *

  • Users: syammerc
  • Order by date
  1. syammerc

    How to Increase the Number of Instances in Event Server

    Hi All, I created a IFD( Integration Flow Designer) for a single map having one input as a file and Source Event is ON (event trigger) in IFD for input. If I got 20 files per sec in a source directory, my maps has to trigger 20 times per sec. I mean where I can I set number to instances for a...
  2. syammerc

    How to call a stored procedure having blob datatype as input paramater

    Hi Janhes, In the above case, the procedure which Iam calling is not having out parameter, it is having BLOB datatype as in parameter. So GET function will not help me. Because I have to parse the text item to stored procedure as BLOB parameter. So please help me how to call the stored...
  3. syammerc

    Handling double-byte data values in Mercator/DataStage TX

    Hi, I hope this will work, but Iam not sure. Can you use the datalaunguage in Type Tree set to UTF-8 instead of native. Make sure your mercator libraries should support UTF-8 datalaunguage. Syam..
  4. syammerc

    How to call a stored procedure having blob datatype as input paramater

    Hi janhes, I tried by calling function as well as with procedure also, but I am not sucessfull. I did not find the function STREAMTOHEX in my version 6.7, So I tried with STREAMTOHEXTEXT function. If I use the above function I am not able to compile the map itself. When I Build the map it is...
  5. syammerc

    How to call a stored procedure having blob datatype as input paramater

    Hi BocaBurger, I am trying to call the same procedure through sqlplus command prompt. But I am not sucessfull. I am trying to call through sqlplus. Please give your ideas or suggestions on this. Thanks in advance Syam.
  6. syammerc

    How to call a stored procedure having blob datatype as input paramater

    Hi Janhes, I am trying to insert Blob datatype into database using Stored procedure. (Stored procedure will do the business logic and insert data into the table, for your information there is no problem with the table) I converted the Blob text into binary and placed in the parameter while...
  7. syammerc

    How to call a stored procedure having blob datatype as input paramater

    Hi Janhes, I am using the DBLOOKUP function as follows: DBLOOKUP ("CALL myproc('"+Name:Record+ "', '" + text(SIZE(Blob:Record))+ "','"+Blob:Record+"' )", "-DBTYPE ORACLE -CONNECT oracle8i -USER scott -PASSWORD tiger -T" ) Please let me know if you require more information. I am able to...
  8. syammerc

    How to call a stored procedure having blob datatype as input paramater

    Hi All, I created a stored procedure having Blob datatype as an input parameter. Ex: CREATE OR REPLACE procedure myproc(name in varchar2, blob_data in blob. I am trying to call this procedure in Mercator using DBLOOKUP function with call syntax, but I am getting error as datatype of parameter...
  9. syammerc

    IF Function Failing

    Hi, This is the first time Iam facing this type of problem. I didnot faced everbefore. TO evaluate the condition I use IF function like Objects Map Rule varible[1] ="OK" variable[2] =IF(variable[1]="OK", "PASS", "FAIL") I am always getting "FAIL" value in varibale[2] I am...
  10. syammerc

    Executing Shell Script from Mercator using EXIT function

    HI, I am facing a problem while executing the shell script from Mercator using EXIT function. I given the command in my map as below: EXIT("<path of my script>< inputparam to script>" ,"","") but map is not executing this script on my UNIX box. The same script is running fine when I tried...
  11. syammerc

    BulkLoad OCI through Mercator

    Hi Janhes/eyetry, Thankyou for your support. I am facing a problem while executing the shell script from Mercator using EXIT function. I given the command in my map as below: EXIT("<path of my script>< inputparam to script>" ,"","") but map is not executing this script on my UNIX box. The...
  12. syammerc

    BulkLoad OCI through Mercator

    Hi, We are using Mercator6.7 version and Iam trying to improve the performance in Loading data into oracle(9i) database. To load large volume of data mercator is taking more time compared to DataStage. I tried with so many scenarios like workspace and pagesize and pagecount but I didnot get...

Part and Inventory Search

Back
Top