Search results for query: *

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...

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...

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..

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...

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.

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...

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...

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...

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...

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...

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...

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...