DSXchange

The only way to be sure is to use a "robot", automated keystroke routines that replace the user actions. We are using Blue Prism for similar work, replacing high-volume, repeated user activity (like acting on data defects that require updates via a user interface).

Good luck.

Jagan had trouble composing his questions, and there's no fault to him for that. Nine-tenths of support is getting the right questions asked, and I've been on both sides of that challenge many times.

The first bug: col9 should have the signed attribute. Can you post the CFD file you used in the Wizard? Edit: Charset should be EBCDIC. Strike this. Sample line for one of my files: record_length=200, delim=none, quote=none, binary, ebcdic, native_endian, charset='ISO8859-1', round=round_inf, nofix_...

Additional thoughts: You don't need to deliver the file to the mainframe to verify it. Use View Data in CFF Output tab, which will carry the column and file attributes you need. If it looks right in View Data, then you may have a problem with the method you use to put the file on the mainframe. How ...

Respectfully, solutions that are outside the CFF and Transformer stages and their default functions should be considered last resort. The entire point of CFF is to make work with EBCDIC formats out-of-the-box. Your amount column attributes should look like the following on the Records tab of the CFF...

There's a way to be sure by doing several steps instead of a direct transformation. From input: Concatenate a leading sign to the Char "123456" into a Char stage variable. StringToDecimal from stage variable to a signed stage variable defined as Decimal. DecimalToDecimal from second sv to ...

I don't have a text to packed decimal example, which surprised me a bit. I do have a PD to text example.

Be sure the out-link column is properly defined as signed packed decimal. In a transformer use StringToDecimal, and see what happens.

I would expect it to work. It works perfectly in reverse.

https://en.wikipedia.org/wiki/Spaghetti_code "Spaghetti code is a pejorative phrase for unstructured and difficult to maintain source code, broadly construed. Spaghetti code can be caused by several factors, such as volatile project requirements, lack of programming style rules, and insufficien...

Point of clarification: are your parameters locally set for default value in the file? If that's true, I strongly recommend "elevating" the local parameters to environment variables. This is standard practice in our elevation protocols. Any parameter that is based, even indirectly, on the ...

The stage will have four outgoing links, three for your custom conditions, and the fourth for "otherwise".

Word of caution: the three will need to be very specific in what they cover. It can behave very much like a nested If statement, and the danger of negative logic is there as well.

Assuming TWS is Tivoli Workload Scheduler... https://www.ibm.com/support/knowledgecenter/SSRULV_9.1.0/com.ibm.tivoli.itws.doc_9.1/awsmsmst.pdf AWSBIS262E No argument was supplied with -r. AWSITA262E The user cannot launch this job because he does not have the required permissions. Explanation: >The ...

An old Cobol programmer suggestion learned from an even older Cobol programmer... If the two versions of data are identically formatted -- meaning there's no difference between DB2 and Hive -- you start by doing a bulk unload on each side. You can do a full-record comparison to identify rows with di...

You'll find a link to the FAQ on using mainframe data at the end of my post. In general, what you have here is a failure to communicate fully on the Cobol programmers who concocted this mess. You have one header record and two types of data records. It will be tedious, but your best bet is to work b...

You're welcome, Craig. We have thousands of jobs on multiple platforms -- z/OS, Unix and Windows -- which run nightly and are dependent on variations due to holidays and time constraints. Our ROI for Control-M is rather good. I don't know if BMC has "light" versions for smaller shops, but ...

BMC Control-M "about" and usage manuals documentation:
https://docs.bmc.com/docs/display/publi ... umentation

I checked the links, you don't have to log in to view them.