DSXchange

Hi Andy, The routine performs Base64 Encoding of input argument and then performs AES 256 bit encryption using opessl, in the same job I am decrypting the cipher after performing base64 decoding. Every pointer I have used in my code except the returned one is free'd and the job aborts after 55 milli...

Hi, Rather than posting in a four year old thread of same subject which is marked "Resolved" felt it appropriate to start a new one. Curious to know if DataStage (8.5) has the feature of freeing the memory of pointers returned by parallel routine on a per row basis (or some interval) rathe...

Hi, I understand its a very old post but posting the function for those who might need in future. Below is a "tested to be fine" version of C routine which decodes base64 encoded text. Define a parallel routine in datastage with one input argument of type char* and return type char* and us...

Thanks Ray

What surprised me was that none of such property was seen to be set in the sequential file stage. Is there any possibility to set this property at project level or job level as I can't see anything at the stage level.


Thanks
Zulfi

Hi, I am using Version 8.5 FP1 and found that the sequential stage is able to read just the columns defined on the columns tab and no longer needs a complete column definition any more (as compared to V7.5) Any one here knows which specific version included this feature the first time ? Thanks Zulfi

Hi Craig,

I wish I had the opportunity . People come in .... develop ... and vanish and the best part of all, nothing gets documented.

Was just trying my chance if it is a kind of expert formula used by experts to achieve some specific thing.

Thanks
Zulfi

It just flashed my mind that the second argument to BitXor function is to ensure the key length(in terms of digits) is atleast as long as the second argument, still wondering why the "+555555 "

Hi, I have come across the code fragment in one of the jobs that generates keys when the key is not found in database reference table. BitXOr(var,9999999)+555555 var is the max value of the key from database. I am unable to figure out the intention of above code and the numbers being specific (no bu...

Found this thread close so posting it here. I have installed websphere Datastage 8.0 by pointing to license.xml and all was fine, after an year i need the license.xml file and I dont recollect its location. In web console no path to the file is listed under Licensing (can view the licensing info the...

Thanks Mike.

In such case I guess even if I use one of the ISO code maps the unicode property would force the column data to be interpreted as UTF-16


Thanks

Hi, For String columns the extended property in columns tab has an Unicode option, My character map is set to UTF-8 which is a variable width encoding. I am confused as to what difference it makes when the unicode option is set, even when unset doesnt it treat the string column to contain unicode ch...

we scream all the time "don't use kill -9" but there is always Atleast one who wants to mess things up. I wish there was a criminal law in place to punish such action

Thanks Ray. The lock I can see for the log is an "RU". I guess the script you are talking about is cleanup_abandoned_locks.sh. Per my understanding the locks are maintained both within the universe and in Xmeta and if I am correct, removing the lock record in XMETALOCKINFO table would also...

Hi, One of the jobs log had a lock which prevented it from being compiled and one of the developers apparently issued "kill -9" to aggravate the situation. Now we dont see any session relating to the same in webconsole but one process appears in the datastage log clean up resources with st...

Hi I am trying to save a group of records into cache and process them at the last record of the group. The expected result is a subset of the group records. The issue is when a filter is applied for example on a group of 5 records and last 2 of them pass the condition (specified on output link const...