Gary Spaulding is now a member of Mainframe
Apr 18
Gary Spaulding replied to Brad Knoblauch's discussion Optional Data Sources in DMX
"Brad,
You could have a custom or extended task that always does a 'touch file' command on your source as a step right before the task runs.  An empty file will be created and the task will read 0 records or if the file already exists, it's last upda…"
Dec 20, 2016
Gary Spaulding replied to Syed Faiz's discussion Mapping column Names in DMX for Hadoop
"Yes - understood.  Not sure I have any silver bullets for this one. 
As far as I know, this would require you to click through the mappings since there is no good way for DMX to know which field should map to which. 
You could certainly automate the…"
Aug 4, 2016
Gary Spaulding replied to Syed Faiz's discussion Mapping column Names in DMX for Hadoop
"So you are trying to change the source layout (copybook) to an alternative layout that has a subset of fields and potentially different field names - is that correct?  Are you able to share your copybook and what you want the final layout to look li…"
Jul 22, 2016
Gary Spaulding replied to Syed Faiz's discussion Mapping column Names in DMX for Hadoop
"Syed,

If you are just ingesting and migrating the data along with the EBCDIC to ASCII/UTF-8 encoding conversion, you can avoid mapping each and every individual field by just mapping the layout level item.  This will become a composite field in DMX…"
Jul 15, 2016
Gary Spaulding is now a member of SILQ
Jan 19, 2016
Gary Spaulding left a comment for Mallik Reddt
"Malik - you may have better results posting to the groups - either DMExpress (DMX) or DMExpress for Hadoop (DMX-h).  If you contact support, they can send an example.  It should be as simple as choosing Mainframe Variable for the source file type, b…"
Oct 6, 2015
Gary Spaulding replied to premkumar sathiamoorthy's discussion Integer as Parameters in DMX for Hadoop
"Not sure I completely understand your requirements.  Are you trying to set target length or pass in some integer value to be picked up in a function?  For the latter, DMX supports environment variables (as text though).  You can use something simila…"
Oct 6, 2015
Gary Spaulding replied to Brad Knoblauch's discussion Kill and DMX Job from Command Line in DMX
"Brad,
You should be able to perform a kill (not -9) on the main process - typically your initiating shell command continaing dmxjob /run and that should trap the signal and send it to all subprocesses.  You could also kill the dmxjob /run command pr…"
Aug 6, 2015
Gary Spaulding updated their profile photo
May 26, 2015
Frank Koconis and Gary Spaulding are now friends
May 19, 2015
Gary Spaulding replied to Danny Padilla's discussion Exit or API to post numeric into a current column in DMX
"Have you tried something like this as a new value?
DateLastDay(DateAdd(Today(),-1,'MONTH'), 'MONTH')
Not sure if I completely understood your question, but perhaps playing around with the above expression should get you what you want.
I don't see a…"
Sep 29, 2014
Gary Spaulding replied to massimiliano's discussion sort copy DMX in DMX
"Never seen that one before and I have seen many errors.  It implies that it is try to overwrite the file (or truncate it first) but the operation failed because the file is not there.  Almost seems like a timing issue - DMX checked and the file was…"
Sep 29, 2014
Gary Spaulding is now a member of Cloud Solutions
Aug 15, 2014
Gary Spaulding updated their profile
Aug 15, 2014