Search results for query: *

Hi there Does anyone have any ideas how to load xml into table using sqlldr, just the data, don't need to load the tags. Can I setup ctl file somehow to handle this?

Hi there Is there any way to stop map execution, I currently use FAIL function but this doesn't suit as I'm logging on failures, I want to stop and move on to next event without logging. Any ideas apreciated.

Datastage TX 6.7.1 Hi there I have moved all my files under development to another directory and I am trying to change the details of the maps within the Integration flow designer but when I edit the map component and try to point to the new directory / map i get the following error -...

Hi there Trying to set (change)a UNIX environment variable from within a map. On start of the map the env variable is set but I need to change it during the running of a map to something else? I tried =EXIT("NAME=2"," ", " ") in seperate output card but map still seems to use original env...

Hi there Anyone used Merctaor to handle XDR formatted XML data?

Hi there I want to run a functional map where I pass 5 values from fields created in the same card but above this field, my problem being that in4 and in5 can be NONE, but the functional map doesn't run with NULL inputs, I'm sure I've worked arounf this before but I cant remember for the life...

Hi there Any give me a hint how to extract unique valies from a series? e.g. 12234455677 From this series I would only want 1 3 and 6 as they only have one entry Any help much appreciated

Has anyone used the WinCVS source control tool for Merctaor projects? If so, how do you get Mercator to recognise this in File>Source Control>Create Project ??? Mercator keeps reporting it is unable to detect any version management software?

How would I add a <NL> to the end of a message being passed in using the ECHOIN syntax? =RUN ("run_gedmequity", ECHOIN(1,(gedmequityIn)))

Hi there I am using the backup switch to append errors from an input card to file. The problem being is that we read these messages from a channel and they don't have a <NL> at the end so the backup file created/appened is just one long line instead of one line per message. We don't have...

Anyone know how I put the audit options (-AEWU) when using ECHOIN command? =RUN ("run_gedmequity", "-AEWU -T -WM -IE1S"+ NUMBERTOTEXT( SIZE( text(gedmequityIn)))+ " "+ text(gedmequityIn)) =RUN ("run_gedmequity", ECHOIN(1,(gedmequityIn)))

Can anyone suggest a way to find multiple entries in repeating fields of xml input e.g. I have five repeaated fields with values as below which I read in using a functional map. ONE TWO TWO THREE FOUR I can only think of using COUNTSTRING for each optional text and see if value >1 but this...

I need to take in an xml input and use some of the fields to run a database select to get multiple rows back which I need to process, from this I need to call a database procedure passing values from input xml and return from select. Any ideas how to go about this?

I have a .csv file in the following format 123,"abc",456,"def,ghi",789 Anyone know how I can change the delimeters in this from comma to pipe (|)? noting there is a comma within a text field.

Hi there I want to write a map that runs for every log file and produces a summary file removing all the log files. I have written a map that does this but I am wondering if anyone has a btter solution to getting all the log files onto input. I tried using the file watcher (source evnt) on the...

Hi, I’m having a problem using dblookup to call an oracle procedure. Historically, the mercator map was using a connecting to the database under the same schema which owns the procedure, and the procedure was called using the unqualified procedure name. Now, as part of a security project...

hi there I'm looking for the best method of loading a file to a database, I need to load 2 rows per row from the file with different details in each row. I thought about having 2 output cards but I believe this will have to have multiple connections to the database rahter than one, I could be...

Hi all I have an issue using the PUT function returning a zero code when a fail happens with the mail adapter so I've been told I need to use a RUN map to call adapter. Can anyone explain how to use a RUN map to call the mail adapter. I need to read to, from and server names from a config file...

I have file and a ftp conformation file that is ftp'd onto a UNIX server each day, at which point the event server should pic the file and process it. The problem being that the files are date stamped (e.g. filename08092004.txt filename08092004.cnf is there any way that you can use dated...

Hi all I am using the EMAIL adapter and just wondered whether anyone knows if it is possible to add a <NL> in the text field? =PUT("EMAIL", "-PROTO INET -FROM user -TO '"+Value Field:.:Properties+"' -SUB subject -TEXT line1???<NL>???line2", data )