Recent content by mjnaaktgeboren

I do something like this I get my info from an oracle table in another card specific to the filename.... I change the attachment name dynamically. This might be more complex than you need, you might just want -ATT " + GETFILENAME(input),TEXT(input) hope this helps PUT("EMAIL","-PR INET...

Has anyone gotten sftp to work as a transport method (ie sftp username@hostname.com) as an output adapter? We have the security option installed. I get an ERRORCODE= 9 ERRORMSG= Target not available userid and password are correct, but could I be using the wrong adapter for this transport...

I am trying to run a database override - we have 17 machines that the databases look the same, but are not.... Anyway, query_db misc_elements:runmaps_parms would = "dpmax" I tried several different ways to override the runmap output to different databases... as seen in card...

I figured it out - you have to use the ' char in the sql/mdq file. ie Select * from MyTable where AbbrevCol = '#TYPE#' Thanks all

Help!!!! I am trying to override some sql variables, and I can override the numerics with no problem, I can pass text no problem, but the issue is that I have to override the sql with a TEXT field containing the ' character because I am accessing an oracle database. Anyone have any ideas? I...

use -URL "https://etc/etc" that works.

nevermind.... I forgot part of the statement. Duh.....

I am trying to use the HTTP Adapter for this, and it gives me "invalid URL" Should I be using a different adapter? I have HTTPS://Host/File It looks like the FTP adapter works FTP, FTPS... should I use the FTPS? I was intending on using ftps:// for the sftp, and I cannot sftp to an https...

I have a long-term "scheduler". It does a different type of scheduling than mercator, and checks a table, creates a parm file with necessary info. This worked so well, that I decided to create a short term one as well. I do this with an Oracle adapter override. I can check the input and parse...

I have a (several of these) single instance of code, and am running it with different overrides, and different compiled names. I would like to pass the 'compiled name' to an error report output. If I knew how to pass the 'commandline' type from the audit then I could do this faily easily. I...

Is there a function or way to retrieve the name of the map you are running into a map rule?

I am not sure I totally understand the error, but if you are saying it's running out of space on the mainframe, I have gotten around something like this in the past by pre-allocating and appending to the file on the mainframe.

It is the anon login, but it's a different password. Thanks, I will look into the RUN Map override.

merc ver 6.7.1 on hpux 11i From what I read on netrc you have to be sure $HOME is set. I modified hostnames/ips/emails for sec reasons, but here is the output from command line, and mercator. It's simply not picking up the .netrc file. I have a default statement for all ftps not in the list...

This does work in our test environment, but causes crashes in our production environment. It has been stable in test for a couple of weeks, but not at all in production. I can't find any maps or "check scripts" reading it, but I suspect that may be a majority of the problem.