DSXchange

Hi bhasds,

The value displayed in the log is encrypted value for password. My requirement is that I need to use the password from environment variable and use it to connect to Db2 database in my shell script. You have any thoughts on how to achieve that?

I did use this command to get other field values. Now, the challenge lies in decrypting password field values. Thanks a lot for your help.

Thanks for responding. How do I retrieve the value from DSParams in shell script? I'm not familliar with that.

Nope but I'd wager others with DB2 and DataStage experience do. What about whatever passes for a 'stored procedure' in DB2? A typical workaround would be to craft a procedure is owned by the table owner that performs the function in question and then your ETL functional user would be granted the ab...

Hi, I'm executing a SQL statement in Unix shell script, which in turn calls a Datastage job. I want to connect to Db2 using login field values from Parameter set's environment variables. These environment variables have default value as $PROJDEF. I want to capture their value stored in a specific va...

My DBA said they cannot give DBA privileges to the User ID to perform SET Integrity in After-SQL property. He said in order to avoid tables with refential Integrity getting in check-pending state after bulk load, I need to load the whole hierarchy , because when you load just a child table DB2 puts ...

How can I Bulk Load tables with referential constraint, using Datatsage without leaving them in a check pending state?

I tried to load data into a Db2 table using DB2 Bulk Load utility on Datastage. Non-recoverable option was set to true. Load finished successfully but left the table in a 'check pending state'. The table has referential constraints on it. I tried to bulk load a table with no referential constraints,...

Thank you! It worked.

I want the generic job to extract data from a table and load into a dataset. Tablename, table definition should be given at runtime. My source is Db2 database table for which I'm using db2 connector. I am going to test RCP method today and see if it fulfills the reuirement. Thanks for your help.

Can a table definition be passed to a job at runtime? I have a requirement to extract contents from different tables and the client wants me to generalize this process by passing parameters for table name and table definition. I personally think this cannot be done but want some confirmation from th...

If you use the indicator columns method I mentioned previously, then the lookups will be easy to setup and transformer logic is pretty straightforward (depending on what you need to do for non-matching codes). I tried the indicator column method and it worked after I changed the lookup failure cons...

We can't predict the performance effect for you. However, what you may gain through using multiple lookup stages is easier maintenance of the lookups (fewer lookups per stage is easier for me to manage, your experience may be different) as well as the potential for better pipeline parallelism as on...

What I'm trying to achieve is, validate around 60-70 code columns in the source dataset by looking up in reference code tables. Code columns in source are nullable. I need to capture records where there was no match for codes but at the same time continue passing those records forward to the next st...

Using one lookup stage did not give desired results, but then again to lookup around 60-70 codes, will I need to use that many lookup stages? How badly will it affect the job's performance?