Recent content by Shrini4u

Hi, Yes! it is possible to to create a mercator map that reads from an IDOC (output from SAP) and inserts it to a Sybase database and/or Oracle 8i. For reading the IDoc from the SAP you need to use ALE adapter which will pull the Idoc from SAP and make it available as an input to the Mercator...

Hi, I think we dont have any commands for FILE adapter which will allow us to append the new contents to the file. Probably what you can do is : 1> Add an input card with one text field say FileContent of max length which will take all the contents of file to which u wanna append the new...

Hi, The error might be because u might have set ur delimiter as TAB or sapce in that particular record if that is the case then try to change the delimiters. If it is not the above case please let us know more about the group properties where this field resides. Cheers, Shrini.

On the lines of the Tim, probably what you can do is create 2 fields in the map in the first field you can use the Exit command like : Exit ( "ls " , "*.extension" , " " ) whose synmtax is : EXIT (program_name, command_line_arg1, command_line_arg2) which will give you the list of whatever...

Hey thanks Theophilos. Can you please tell me how can we do this without using the awk command? Thanks in advance. Regards, Shrini.

Hi, How can I list only the filenames in a directory without showing the Directory names while listing a particular directory. Thanks in advance. Regards, Shrini.

Hi Myggiz and Vibhav1008, Can you please please.... upload the project estimation document on some place on the Net so that we can all have access to it, if it is not possible can you please send it to me my address is hishrini@hotmail.com really appreciate your response. Thanks in advance...

Hi, If you are running your maps on the UNIX server probably what you can do is use the EXIT function where in you can call a Unix script which will take care of sending the mails and pass the txt file with the email address to this script and use mailx command. e.g...

Hi, In addition to what rivell has said just small note that the Extract function will pickup multiple records matching the condition specified in the Extract function if you map the above rule in details(s) field which is correct, but if you map the same rule in the header(1:1) field (which I...

Hi, I am not the Oracle guru..but I do know about Oracle somewhat:-) cheers, Shrini.

Hi, If you see the q? the data is : DTP*301*D8*20010101** DTP*348*D8*20020202** DTP*303*D8*20030303** so as u can see there are multiple DTP segements so you need to lookup for each occurance of DTP segment in which case LookUp can be used to find the particular value but as I explained...

Can anybody tell me What exactly is the diierence between Gentran and Mercator? I know about Mercator but don't know about Gentran/GIS? I heard about Gentran suite that it also has mapping stuff in it as we do in Mercator. Any comments on this most welcome. Thanks in advance. Shrini.

Hi Kumar, What you can do in this case instead of sorting the data is create a functional map say F_DTP and pass 2 instances of the same segment i.e. DTP segment like : F_DTP(DTP,DTP) and name the input cardes in the func map as DTP1 and DTP2 then you can use the command Either as shown below...