DSXchange

In your above response, you've mentioned that support from IBM pointed to the fact that you were still pointing to the "Internal User Registry" due to some misses in OK/SAVE clicks. If that were the case, how is it that your isadmin and wasadmin users were deleted.... as suggested in your ...

On similar lines, IBM says that if the User Registry in WAS was set to Federated Repository, then you can add the isadmin and wasadmin to the local repository, and hence, be able to authenticate against both, LDAP or the local internal registry. Check the link here - https://www-304.ibm.com/support/...

Assuming that your sequential file contains the rows in that order, in the Transformer, create a stage variable where you compare the previous value of the concatenated keys with the current value.

Try: Here, "T" implies Trailing.

If your process is the only one that will ever load the table in question then state file should be ok. If there is a chance that other applications may start entering data, then a db sequence object ... I agree with DSguru2B. We use db sequence only for those that require inserts from various regi...

I am getting a similar error when trying to import XML Metadata. I get the error: ActiveX component can't create object: VMDataStage.CDSXMLMDI I can, however, go to my DataStage client directory and manually bring up the XML Metadata Plugin. Can somebody help me what might I be missing? Thanks, Hi, ...

For small volumes of data a server job can be started, run and finished before a parallel job has completed its startup phase. Ray, what would you consider a "small" volume, versus a "medium"??? or "large" volume? What about load times differences between server and pa...

Concatenate all your non key columns from source into a single value and pass this value to CRC32 function. Similarly calculate CRC value from lookup/target table also. If the Key column matches and CRC values doestnt match between source and lookup then it is an updated one. I would place some kin...

svhari76 wrote:Hi

How can i convert String MMDDYYYY to Db2 date MM/DD/YYYY ?

Eg: '11302009' to be 11/30/2009

Try-

BTW, I have left the Separation to default of 1.

I'm trying to convert a date to the format YYddd (day of year). Is there any way to do this inside a transformer? I've been trying different things for a couple of days and can't get anything to work. Assuming your input date is in the format YYYY-MM-DD, try this- Oconv(Iconv(InLink.YourDate,"...

I need to create a Static Hashed File that contains the following columns- Total number of rows = 10,000,000 (10 million) SomeDateAndTime KEY, TIMESTAMP(19) eg. 2010-05-12 09:30:45 FirstAmount Non-Key, INTEGER(7) eg. 1234567 SecondAmount Non-Key, INTEGER(7) eg. 1234567 I am using the HFC calculator ...

You could use an Interprocess buffer between the Transformers so that an otherwise single process be split among the CPUs. Let us know the result if you think it may result in an overall performance gain.

Hi, A sequential file has 8 records with one column, below are the values in the column separated by space, 1 1 2 2 3 4 5 6 In a parallel job after reading the sequential file 2 more sequential files should be created, one with duplicate records and the other without duplicates. File 1 records sepa...

I use the dscmdexport.exe command wrapped in a batch script that is scheduled from Windows client (that contains DS client) to create the dsx file. It creates a single dsx file for a project and contains jobs, routines, table defintions, executables etc. Whenever I want to split them into individua...