DSXchange

Protect or Unprotect a project in DS 8.1 - Is there a way to script this task so that we can avoid the usage of the Administrator client to do this? What I am trying to do is write a small script that could be run by dsadm or root when a project needs to be protected or unprotected. The project name...

Your search should have turned up the fact that this is a known issue with that particular command line option, from what I recall. Contact your official support provider and see if there is a fixpack / patch available to rectify that... I honestly don't recall. Thanks for the quick reply Craig. Ju...

Hi, I am writing a unix script that gets row counts of records flowing in and flowing out of the job. To achive this, I am first listing all stages in the jobs and searching by naming standsards to detemine if they are incoming or outgoing stages. When I issue the command, dsjob -lstages ProjectName...

I think the best way to capture duplicates is by using "Sort Stage". Define the columns for which you want to find duplicates on as your sort keys and enable "Create Key Change Column". This will create additional column "keyChange". All rows with the value of '0' (zero...

Thanks Ray. It worked.

Best thing is to read the "Configuration File" Chapter in documentaion. You will get a clear picture of what configuration file is.

Also, when copied with "orchadmin cp" datastage uses default config file "default.apt". Make sure that the configuration in default.apt is the one you want to use.

Hi all, The APT_STRING_PADCHAR has been initially set to 0x00 and when data is loaded to DB2, DB2EE stage has padded weird boxes for each Char field. http://www.uploadgeek.com/uploads123/2/NullChar.JPG We have changed the value to 0x20. But we need to correct existing data. Can any one of you sugges...