Brad Knoblauch replied to Erik Lee's discussion Checking and handling duplicate keys in DMX
"Can you provide a few more details and some example data of the source and what you want the target to look like?"
Jan 4
Brad Knoblauch replied to Brad Knoblauch's discussion Optional Data Sources in DMX
"Thx Gary... that's exactly what I did.  I created a custom task that "streams" the data from the file to standard output and used a pipe as the source input in the next task.  If the file does not exist I simply throw the error to /dev/null
#!/bin/k…"
Dec 22, 2016
Brad Knoblauch updated their profile
Dec 16, 2016
Brad Knoblauch posted a discussion in DMX
I have a need to extract some data from a database and "optionally" some data from a file if it exists.  Since the database is always up and running... no issues with this source.  However, since the file is NOT always present the DMX task fails whe…
Dec 16, 2016
Brad Knoblauch replied to timothy zimmerman's discussion Unix datasource configuration in DMX
"Did you setup the environment variables too?
ODBCINI=$DMXHOME/etc/odbc.iniODBCSYSINI=$DMXHOME/etc"
Jan 19, 2016
Brad Knoblauch replied to timothy zimmerman's discussion Unix datasource configuration in DMX
"Are you trying to connect from your client tool on Windows or on the Unix server?  When using the Task editor on your Windows computer, you need to have the ODBC setup locally to design your tasks.

On Unix server there were  2 files in the $DMXHOME…"
Jan 19, 2016
Brad Knoblauch posted a discussion in DMX
I have executed a long running DMX Job via the commnad line (ie. dmxjob /run J_Master.dxj) and want to kill it.  What's the "cleanest" way to kill all the asscoaited processes?  As you can see below, there are a ton of processes that got kicked off.…
Jul 20, 2015
Brad Knoblauch posted a discussion in DMX
I have a table with a PK and a BLOB column I need to inerst into.  DMX only supports the inserting of a Large Object via the "Table" tab... so I can't use User Defined SQL.  However, you also can't enter the Oracle sequence name in the mapping.  Any…
May 18, 2015
Brad Knoblauch is now a member of Syncsort Community
May 18, 2015