DSXchange

Just in case this could help...
The purge rules apply only for new jobs. If you set the purge rules after deploying your DataStage jobs then logs won't be purge for those old jobs..you would need to redeploy them

Hi Chulett,

Yes The IA Data Quality rules functions are completely different ...if the substring not exist within the string a -1 will be returned. Is also a different mind set to work with IA data quality rules

...I would do below

- Test without the second condition "then cash=0" to discard the possibility that this one is causing the rule not to work on the records
- Test with hard coded values
- If nothing work then I would use "matches_regex" instead of Index

...There is a bug in IIS8.7 that prevent the multi instances status records from being purged or cleared. The actual DS logs will be cleared as per the setting in the auto purged but not the name of the instances in the DS director view and will become slower and slower to refresh the logs due to th...

Well, the result of Index function is a zero-based index, a zero indicates that the substring was found at the beginning of the string If you use >= operator instead of just > it will work in all cases index(name1,'Recycler') >0 then cash = 0 when the name1 is 'Recycler GL Walmart 1068 OLMM' index(n...

IGC REST API: Tips, Tricks, and Time-savers

http://www-01.ibm.com/support/docview.w ... 7054&aid=1

All that needs to be done is stated in below IBM tech note

http://www-01.ibm.com/support/docview.w ... wg21500980

Regards

By default you should be getting the fractional part of the values truncated if the Oracle field is define as number(p,s) and the DS metadata for same field is define as integer ( it truncates the fractional part of the decimal value), but I guess that due to run time column propagation you are not ...

Todd,
Below the reference from the IBM website, you could do with the HTTP api almost all tasks that you could via the GUI

http://www.ibm.com/support/knowledgecen ... l_var.html

Regards

See if this technote help
http://www-01.ibm.com/support/docview.w ... wg21503212

Hi Todd,
version 11.3 is a bit buggy. Try with the HTTP Request POST create command directly. That would add the global variable, set the it values or binding all without without using the GUI layer

Hope it help ....

I guess that the script is not sourcing the dsenv file properly or the dsjob command is not fully qualified. Test if the command runs fine from $DSHOME/bin after sourcing the dsenv file...If it works then check that part of on your script We issue the command with same syntax in our shell script and...

If you process small files the job finished OK? Ensure that the process works with smaller files then increase the sizes up to the point where it fail before starting the tuning exercise I took similar approach while parsing a huge XML file and couldn't tune enough the setting to digest the file... ...

What's a remainder? For a division's remainder use the module function (%) directly. If you meant the fractional part of a decimal value that could be extracted using trunc() or round() functions as shown below DecimalValue - trunc (DecimalValue, 0) DecimalValue - round(DecimalValue, 0) 123.45 - tru...

Umesh, What happens when you run one of the parallel jobs by itself from DS Director? One that you have in that DS sequence...Did it execute in one node or four? Could you put here the value of the environment variable APT_CONFIG_FILE from the logs? ( I know, you stated that it is set to 4 nodes by ...