DSXchange

ray.wurlod wrote:Not at all. One flight to LA, one flight to PA.
...

Have you ever done a layover in an airport while drunk or with a hangover? That's not an experience I'd choose to repeat.

If you add $OSH_PRINT_SCHEMAS = true to your job parameters you can see the actual schema used between your stages. You are converting HOSP_NUM to a datatype with less possible value and thus you are getting the warning message. The best solution is to explicitly convert the data to the same types ...

Party! ... but getting home from Australia afterwards would be a little difficult. :D

Does your input file have a header record or column headers in the first sequential record? That might be why your maximum row number is greater than the number of data records. That's a guess, because when the documentation says "column header records are ignored during processing" it doe...

Possibilities: The file being looked for has a permissions problem for the user id of the job looking for it. Check your permissions mask for the folder. At the runtime point the job is looking for the file, it has not yet been created. I've noticed that DS's parallel processing doesn't always keep ...

Without going into details (meaning: please don't offer advice on improving this, I fought that fight and lost), here is a sample Unix line to retrieve log messages. if [[ ${JobStat} == ${DSJS_RUNFAILED} ]]; then ErrorDisplay=$(${G_DS_HOME}/bin/dsjob -logsum -type FATAL -max {MaxDsplyErrors} ${G_DS_...

Rumor has it that the 8x version of FTP Enterprise is supposed to be SSHv2 compliant. I'm stuck with 7x and had to get a waiver to not use SFTP. The only workaround I know of is to run SFTP in a non-DS job and land the files on your local server, then read them with your preferred file stage. That d...

...I cannot think of too many reasons to avoid a transform - they are pretty speedy. The restructure stages obfuscate metadata and "can" make maintenance and understanding a bit more difficult. Also, these stages do not imply greater efficiency or performance, just a different tool in the...

Would you be able to post the schema of the dataset used as input? Thanks for asking. I should also add that I can use a Transformer stage and substring derivations without any problem. I do have a medium performance concern, or I wouldn't be trying to avoid using the Transformer. -schema record {r...

I searched all the forums for anything on this error message, and got two hits that offered nothing about it beyond the mere mentioning of it. It compiles cleanly. At runtime it dies on main_program: Fatal Error: Not an aggregate field. [api/schema/schema.C:2173] , not one detail offered or found wi...

I explored this from a different angle recently, and found that CFF must have DS/mainframe installed for direct access between the Unix processes and the mainframe datasets (of any format, including VSAM). I am using FTP Enterprise to get sequential dataset data. I would very much like to see how th...

...I think the main overall issue must have something to do with landing the data to a text file vs. not landing it. I wonder where DS stores the data when it's not landed using a seq file stage. Thanks, Eric I was wondering along that same line: Is it possible that the CPU/memory being used is max...

Romil, I may be missing something, but it looks like you are working against the DataStage weakness in handling Cobol formats that use redefines at the record level. Your reference to a "master record" leads me to that assumption. My suggestion is based on the assumption that the record-ty...

Your points are well taken. I'll just clarify that our host production environment is mostly several million lines of COBOL/JCL under thousands of jobs that run cyclically. When we established centralized production support (I was there for the "bad" old days when the development team prov...

can u please let me know a bit more on how to do the bulk loading That's a DB2 question, not a DataStage one. It depends on the details of your DB2 installation. For example, your first question might be do you have BMC utilities available. If, you do, then it might be a lot faster to FTP your data...