DSXchange

Thank you so much for your reply bhasds, i have tried that logic, but it didn't gave me the required results..It gave me the same result I have already got using the transformer loop without the column names converted to rows with each value.. your solution just added another columns with the values...

I need to do the following data transformation example: Input file : ID, Line1, Line2, Line3 1, 10, 20, 30 2, 100, 200, 300 Required output table structure: ID, Line, Value 1, Line1, 10 1, Line2, 20 1, Line3, 30 2, Line1, 100 2, Line2, 200 2, Line3, 300 Can I Use the Transformer loop to accomplish t...

I have this problem currently, wanted to ask...where have you changed the proxyconfig.xml file... is it on the datastage server or client? as i didn't find a proxy.xml file on my machine!! my current case is that am connecting through my 8.1 client to a datastage 8.1 on Linux Thank you. Hi, I have r...

It was all about permission. I've noticed that 'Run' button was invisible. So, I've granted the user 'Information Analyzer Data Operator' role instead of 'Information Analyzer Business Analyst'. And it worked fine,

Thanks Ray

Regards,

Dears,

I'm new to AI and it has a strange behaviour. When performing PK Analysis, the output is an empty grid at 'Single Column' tab. At Column Analysis, a list of columns is provided but with empty results at Cardinality, Data Type, Length,...

Any ideas?

Regards

1- They are several jobs, extracting data from Oracle 10G database, make no or minor transformation and then loading into DB2 after a CDC stage. (it didn't hang in a particular stage, because it didn't even start it) 2- The job Director shows no abort messge, it's just hangs in: main_program: orchge...

Oracle: Client version: 10.2.0.1.0 Server version: 10.2.0.1.0 DataStage: 8.0.1.0 SuSE Linux 10.1 64-bit Oracle Enterprise stage Reading/inserting from/into Oracle OSH process hangs (100% CPU time), DS client irresponsive Trials: 1- running dsjob -run PROD_ETL test2 Same results 2- OSH process: strac...

Back with solution. :D The main problem was with limiting the DataStage to use only 1.5 GB out of 16 GB of server's memory. After opening a ticket with IBM support, the problem is fixed. The whole issue was about the sequence of starting up WAS and DataStage services and the 'LDR_CNTRL' parameter at...

I think this post might help:

http://dsxchange.com/viewtopic.php?t=13 ... a1d2cf1cd5

Regards.

@Ray, we've discovered that it's a heap allocation error on AIX. This post from IBM says that you don't have to change the 'LDR_CNTRL' parameter at 'dsenv' file in case of server edition in opposite to the parallel one: http://www-01.ibm.com/support/docview.wss?uid=swg21411997 We've even tried to in...

Dears, We've a fresh DataStage v8.1.0.1 (Server Edition) installation on AIX v6. Jobs are exported from Windows Server 2003. After moving to the AIX environment, all imported jobs are working fine except for those which contains Aggregator stage. After reading around 8 million records from the data ...

Did you pick the activity variable from the expression editor when filling in the parameter value expression in the Job activity Job2_Activity? It worked out, Ray. Your question was the key. At job2, I was defining a parameter set not a single parameter on job2 level, so the Value Expression for it...

Ray, I've tried to use 'Job1_Activity.$UserStatus' at Job1_Activity and UserVariableActivity but no output is generated from job2 which means that it didn't receive the parameter at run time. Also, I've examined the log of job2 and the select statement is receiving the default value of parameter? Al...

Dears, I'm trying to pass a runtime parameter to a job which holds a value from a previous one. i.e. selecting max(date) from job1 then passing the result in where clause of job2. After searching, I've followed the following scenario: http://www.dsxchange.com/viewtopic.php?t=132137&highlight=ove...

Dears, I want to retrieve multi-rows from a hash file to be used as reference to lookup transformer. Reference link have retrieved multi-rows when using ODBC stage with a direct reference but I need to hash data first before lookup. I found the following reply by 'Ray' while searching: http://www.ds...