DSXchange

When using the CFF option of importing multiple records by de-selecting the "Single Record" radio button on the Record page. I am able to import 8 different copybooks. However when I try to import the 9th copybook, it does not import. I have verified that the 9th copybook is valid and will...

Well it looks like I was able to work through this one... Just in case anyone is interested, I simply executed a before sql that dropped the primary key which released the RI, then ran my job which did a Delete and Loaded my recs. I then did an after job sql to re-establish my Primary Key. Before Sq...

I am in the process of taking a DB2 source, and loading it back to another DB2 table that has RI on another table. The client is ok with breaking the RI in this test environment. What would the syntax be within the DB2 connector to disable RI within the table before loading?

I want to see if there are any routines available for masking (obfuscation) of specific columns of data within my source file irregardless of the type of source. DB obfuscation is not an option as this is coming from a mainframe and the requirement is for this to be done in DataStage. 1) I need to m...

I have a flat file that contains a Header and many Detail records. My problem is that there is no primary or foreign key to join the records. All that I know is that all of the detail records that follow a particular header record, belong to that header. What I would like to do is to create a sequen...

Check the MQ.pdf Stage guide in: \Program Files\Ascential\DataStage7.5.1\Docs it quotes the following under functionality: "Connects to a single queue manager, but can open several queues. You can associate each link with a different queue." I have job of reading from one MQ1 and puttin in...

Connecting from a remote client on the network versus Connecting via Terminal Server or Remote Desktop to the server work the same as far as the number of concurrent users are concerned. This is managed by the DataStage Server and because your jobs are actually being run on the Server side there is ...

The Sort checkbox is your way of telling the aggregator stage that your incoming data is sorted. By providing this information to the aggregator stage you can cut down on the processing time within the aggregator and you will notice sizeable increases in the performance of large data sets. So the so...

Have you tried to create a test message from within MQ explorer? I would try this first so that you know that the message is going into the queue in a txt format and then try to retrieve that test message. If that works then you might need to look at the process that is creating the message and what...

I have not used the CFF stage however I am "Old School" and I would just use a Seq File and read the record in as Fixed length 2048 then use a Constraint for each link specifying i.e. your example... linkname.fieldname[1,1]='A' for each first character. On the output links you will have on...

Actually splitting this process into two jobs would save you a lot of your problems. Is there a business reason why you would not want to create two simple jobs to handle this as opposed to one job? You could however write to your first table to establish the referential integrity and then within th...