DSXchange

Hi, We are using global parameter set as part of a sequencer. This global parameter set comprises of 5 indiviual parameters. We want to run this sequencer using dsjob command as shown below. $DSHOME/bin/dsjob -server xxxx -user xxxxx -password xxxxx -run -jobstatus $Params \\ ${ds_project} $sequence...

Hi, Datastage will be using osh (setuid restricted shell with enhanced security) to process datastage jobs. These processes appear to be bound to one CPU and are currently consuming 100% processor on CPU2. Can you please suggest any configuration changes which will allow osh to use entire available ...

I dont get any error message while re-creating this file. But it fails while reading this file set in next job.

Hi, I am creating a fileset using four node configuration file. See a sample fileset below --Orchestrate File Set v2 --LFile node1:/opt/Ascential/Ascential/DataStage/Datasets/SupraObject.fsP000000_F0000 --LFile node2:/opt/Ascential/Ascential/DataStage/Datasets/SupraObject.fsP000001_F0000 --LFile nod...

Hi Ray,
I am not a premier member, can you please paste your reply for my quick reference now.

Thanks,
Arun

Hi Ray, Please find existing logic below: 1) We receive following parameter file as an input to this process which will mention fields needed in their output A_B_C_Field1 A_B_D_Field1 A_B_C_Field2 A_B_C_Field3 We create a temporary output file as given below from this Pol|NULL Key1| NULL Key2| NULL ...

Note: In all examples first line represents schema Input file: ----------- Policy Key1 Key2 Key3 Field1 Field2 Field3 Pol1 A B C 10 20 30 This file is created dynamically. i.e Number of fields (field1, field2, field3 etc ) can be changed which will be decided at the beginning of each execution. Look...

We are doing this process in a dynamic environment.i.e.Metadat file can be changed depending on execution. User can select their own fields to be displayed in data file. We have implemented this process using RCP and schema file. I cannot afford to do a mapping here.

We are creating a sequential file in our process (Using RCP and schema file). I want to merge data file and schema file as detailed below. For e.g: Data file: pol1|00|2000-10-29 pol2|01|1999-10-28 corresponding schema file record { final_delim=none, record_delim='\n', delim='|',null_field='', quote=...

Can we connect databases in two different db2 instances in a single job? Description: We have two databases which are configured to different instances. Say Database1 on Instance1 and Database2 on Instance2. We want to build a job which will read TableA from Database1 (Instance1) and wants to popula...

ray.wurlod wrote:Yes, but you will need to install/license the IMS components of DataStage. Contact your vendor for pricing. ...

Hi Ray,
Can you please brief me about the different IMS components of datstage?
Thanks,
Arun

Hi,
We got a requirement to extract data from IMS database (Mainframe) and do transformation before loading into target. We are planning to use datastage for this ETL process. Can we connect to IMS DB and extract data directly using datastage. Please help me.
Thanks,
Arun

I am doing a lookup against a DB2 UDB table using a lookupstage. We are using DB2 enterprise stage to extract data from a DB2 UDB table. The follow SQL query has been executed. SELECT RIGHT(SS_NUM,8) AS SS_NUM_8 FROM FWFD001.FWF_LEAD_ALLOC SS_NUM has been defined as a non nullable field in table. SS...