DSXchange

The source data is in Base64 format!
Therefore it has no NLS characters in it!
the output data after coversion is another thing!
This is the whole idea of Base64; to keep data managable for DB or movement via data protocols while nutralizing the whole NLS issues.

Hi Everyone, I've had to implement Base64 decoding in DS Basic. In short every 4 characters represent 3 characters, so I used the Fold function to create sets of 4 characters to work with. In one case where I convert up to 7k+ characters the job hangs after 50 rows. 10 rows run ok. Does anyone know ...

So after a second look I noticed that the programer used a function that returns a value but invoked it with the Call MyFunc(a) Instead of using RtValue = MyFunc(a) After correcting that mistake it works fine :!: There was no routine by that name that returns no value therefor DS couldn't locate suc...

Hi, I'm trying to call a user defined routine from another user defined routine and I run into this problem: Program "DSU.XX": Line 10, Unable to load file "YY". Program "DSU.XX": Line 10, Unable to load subroutine. Attempting to Cleanup after ABORT raised in stage Xfm....

You still didn't provide us with a reason why would you need to do this. This is not provided out of the box. Beside the conditional routine to use a predefined set of functions and use the desired function depending on the logic I do believe one should be able to implement such functionality by bui...

Hi, You need to refer this to your DS Admins There seems to be an issue with the libraries needed. This might be a simple matter of redirectig the symbolic links of the desired libraries or you might need to reinstall the Stored Procedure Plugin. This should be passed along to your support provider ...

Hi,
As far as I understand,
You are refering to things unique in your organization!
There is no direct need to use citrix as far as the tool is concerned.

I think that a periodical cleansing or a preload cleansing will also leave your data sets available for some debuging in case you need them.

You have the USERSTATUS As Craig Said and the UserVariable Stage that you can use to create your on the fly user variable and use it along the flow stream there after. There is no reason to change the value of any givven parameter during the sequence run, unless you try to bring yourself to a debug ...

In my humble opinion, the fact that the only jobs that are connecting to the database are significantly slower, implies that the problem is your database connection. I can't say if the actual connection or perhaps some database optimezer issue or your network configuration, is the one rsponsible but...

Besides what was laready said you can see that kicking your second job is depended on the end of the first one since you use -wait in your run option, so you might experiancing an increase of execution time for the 1st job, did the data processed had an increase on records going into it lately? IHTH...

Not sure if this is what you wanted but A> the parallel engine always had the auto propogation feature of existing rows with the only constraint that you don't need any data manipulation on those field B>you can always build a job that extracts some data into a CSV file and open it using excel IHTH(...

Hi, This fixed file was created by some other program there for the creator must have the file definitions file. assuming this is a file built by a cobol program it should have a copy book or copy member that defines it. If you get the definition file you should be able to import it and get the tabl...

Hi, Finding the location of any job inside the project in versions prior to 8 is done by querying the project's repository. This is done by commands you run from the DataStage Administrator. Type this sql and hit the execute button: SELECT * FROM DS_JOBS WHERE NAME LIKE '%JOBNAME%'; in the returned ...

Hi,
NLS is indeed an Installation option.
while the client NLS setting is automatically extracted from your client machine's settings it is required that yu have it installed.
Setting your Server side NLS sould be the one without the CS ending
IHTH (I Hope This Helps),