DSXchange

Hi,

I would like to know if there is a facility in DataStage 8.7 version, to provide read only access to the director. By read only access I mean just to browse the repository, monitor and view logs or in other words restrict execution of jobs from director.

Please help me understand

Hi, I am writing data from a sequential file to a dataset. The volume of the data ranges from 8 millions to 20 millions for different files. I need this data to be sorted based on a single key. I am not sure which sorting is better for sorting for better performance with this volume of data Please h...

Thanks Josh.
I would verify your recommendations

I have defined a few user defined variables and created a parameter set. The parmaeters defined are for connecting to target database I have created a job for loading the target DB2 and used the parameters from the parameter set created and I am able to load the data But when there is a change of pa...

Thanks Craig,
I need to verify this on my own as I do not have a dedicated DBA currently
Will post my findings

Thank you so much for the link
I would go through it

Thanks Ray for the information
Could you please tell me how can I connect to a DB2 hosted on zos system using JDBC
I am not sure if it is possible to do it or not

hi,

How do we know if Java pack is available with my installation or not
Version is 8.7
I can see in Real Time Stages
Java Client and Java Transformer

I am able to laod the data without any problems using bulk load option of DB2 but the job fails when used with insert or update.

Can anyone help..please

Hi Craig, I have posted my query here http://www.dsxchange.com/viewtopic.php?t=150009 and later felt this thread on the similar lines. Anyways below are few details Extracting data from DB2 hosted on z/OS codepage is CCSID37 Loading to DB2 hosted on AIX codepage 1208 and codeset UTF-8 The database i...

Hi Deepak,
I have tried using unicode extension but the resulti is same
When I view the data from datatstage I see the value as ???????? but extracting to a dataset and viewing the dataset the output is blank

Am I missing anything..The customer data is Spanish

Hi nsg,
I have come across the same problem as shown in this post.
Could you please provide the trnasformation logic used by you

Hi, This is my first post in DSXchange. The configurations The customer database is of Peru(Latin America-Spanish) SOURCE : DB2 hosted on z/OS codepage is CCSID37 Datastge : Version 8.7 hosted on AIX Configurations from dsenv file export LANG=ES_PE.UTF-8; export LC_ALL=ES_PE.UTF-8; export LC_CTYPE=E...