DSXchange

Wolfgang,

Here is the link for the ODBC drivers for SAS on Unix:

http://www.sas.com/apps/demosdownloads/ ... eID=000333

Hope it helps

Thank you,

Todd

We are converting from the Windows server to AIX. When we apply the SAS ODBC driver we get errors. In the documentation that we are looking at, it states that multiple odbc drivers cannot run simultaneously. Has anyone come across this? Here is the documentation that we have been looking at: You sho...

I checked the permissions on the folder and had the administrator grant me full control on the folder and that still did not work

I am receiving the following error when running a consort plug in and am unsure how to fix it. DataStage Job 2267 Phantom 3132 Program "DSP.ActiveRun": Line 51, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in stage DMR0341MergeIPHandPPHcoso...

As far as I know, I am not using an IPC stage in a server job. I did not speak with a support specialist about this. I was hoping to find out if anyone had come across this error in the past.

Has anyone seen the following error, and if you have, what can I do about it?

ds_ipcopen() - call to CreateFileMapping() failed - Access is denied.

This file is a sequential file being read as input to a job. Fixed width columns. Nothing special.

I have FTP'd a file from an os/390 mainframe to Data Stage and am using the CFF stage to get the data that I need from the file. The data is not correct. I am getting unpacked spaces in multiple locations on the file depending on the record. I am FTP'ing the file as binary and putting it into a sequ...

From what I read on the recent thread, the responses appear to be from after the data is FTP'd to the server. I need to know how to get the data in its native form over to the server.

I am trying to FTP packed data from an OS/390 system to Data Stage 6.0. I keep getting an error that I have a mismatch number of columns between my data and my link. I used a cobol layout for my meta data. What do I need to declare my fields as for data type? I have tried several different types and...

I am trying to read in a Focus File layout. We currently do not have these layouts in cobol, so I was wondering if anyone knows if DS can import a focus file layout.

I am trying to do this from a server job. I know to use the FTP stage, but in our system, we have to have a site file = JES to submit the JCL. Also, I am unsure on how to write the script that was described.

I am using Data Stage XE and what I am trying to do is set up an FTP to the mainframe. The file that will be sent is the JCL for a job on an OS390 machine. I am trying to FTP directly into the JES system to kick off this job. We do not do Data set triggering where I am at, so I need to do it this way.

I have a situation where I will not be getting any data from my source, but I still need to populate a file with some hard coded data and a record count coming from the source. The source gives me no records, so it cannot populate the count and I get no output.

Hi,

I am trying to put a trailer record onto a sequential file after I have gone through the transform. I can create the record, but I am unsure of how to append it to the file that it needs to go onto. If someone could enlighten me, I would appreciate it.

tmelcher