DSXchange

thanks Ray/Ken - I'll give your suggestions a shot and post the results.

Hi Guys Just something I was pondering on while tuning a job. I have a SEQuential stage looking up against a HASH stage and writing to a different HASH stage. This needs to occur like this because I am using "different HASH stage" as lookup/reference for another transformer. The SEQ stage ...

Is this the first time you are compling a sequencer job and getting this error or you have complied successfully sequncer jobs in the past on this version of datastage? Is this version 7.5? This is not the first time, it is 7.1r1 on solaris 9. In another sequencer i have multiple jobs that go into ...

Hi guys Again I sit with a sequencer issue. Job is as follows: ValidateJob ----> SEQuencer (All) ------> emailMe I get, when compiling: Compiling: Source = 'RT_BP442/JOB.2017685127.DT.1341666964', Object = 'RT_BP442.O/JOB.2017685127.DT.1341666964' ****************************************************...

not bad. at least say where the encryption/decryption algorithm is. that way you are not making the horse drink the water.

ogmios wrote:
Let's do a game.... give me an encrypted DataStage string and I will decrypt it.

only if you post the routine on decrypting :D

here you go:

So if you give a log file to anyone containing the encrypted password in it, that person can reverse engineer the password. what? would you mind expanding on this? Or are you just saying that the log file has the password as blatant as daylight - or is there a trick to handling decrypting the encry...

denzilsyb wrote:

ray.wurlod wrote:Then again, my correct password is only seven characters

this one is 9 characters long, with the last one being uppercase 3

fancy that - solaris is only interested in the first 8 characters.

What version of UNIX yes - something i should have added in my first post! Sun Solaris 9, Sparc Generic_117171-05, netra-T12. I tried it again this morning just to make sure i was not high on coffee when i posted the concern. Its still happening! I even tried with a SSH session and surprise surpris...

hallo all to my amazement today i typed in the username and password to log onto the datastage server via the client and logged in. OK, that was expected; although I knew i had typed the password incorrectly :shock: . i.e. username: dsadm password: passwor (it is supposed to be password ) it turns o...

Hi all I decided I would go along with technology and start using Job Sequencer. Its actually quite easy, but I am left in the dark on a few things; I have: 1AJActivity ---> 1Sequence ---> 2Jactivity ---> 2Sequence ---> Mail | | 1BJActivity ----------------------------------------- where 1BJActivity...

Is "Call Application Number" defined as an integer? It might be the metadata that causes the ORDER BY to be handled differently.

with regards to the second issue, test the SUM on something different. If the SUM works there, then the SUM function works; the issue is then somewhere else.

This is how i would try it: In the transform (left pane) link the columns C1 = A, C2 = B, C3 = C. In the transform (right pane) write a constraint that satisfies the IF statement you gave: C1 matches with A AND (C2 matches with B when C3='LINE' or C2 matches with C when C3='POINT') something like......

It depends on the architecture as well. One of our colleagues says they have no issues with speed if the DB2 server and DS server is on the same physical server. But, if you research the forum, guys like ogmios and more are sceptical about the speed achieved using the bulk load. They use load script...

I had a quick look at the documentation as well, and it explains quite clearly that the target source stage can write to a program. The External Target stage is a file stage. It allows you to write data to one or more source programs. The stage can have a single input link and a single rejects link....