DSXchange

Reason? I wanted to create DEVELOPMENT ETL jobs that is based on the existing ones. Let's say we have about 50 ETL jobs stored on Category = PROD (Production copy). However, PROD ETL jobs is not adviceable to be edited if there are changes that needs to be applied. What I'm currently doing is to Op...

Are Sequencer jobs not available in PX/EE? You would use a Notification Activity stage to send an email. Either that or write your own script and use it as an 'After Job' object. On the subject of attachments, this was just discussed this week and probably hasn't even scrolled off to the second page...

The whole point is to get down to something that will load into a numeric field. That makes the 'right' conversion MCN in this particular case because the dash would need to come out. Note that the DIGITS transform (which would make it a little more obvious what is going on) uses the OConv function ...

Never mind, I found it as part of the Help associated with the DEADLOCK.MENU command.

The 'interval timer' is defined in seconds and 'res' is 'resolution strategy'. The valid values are:

0 = Random
1 = Youngest
2 = Fewest Locks

Guess I'll stick with 'Random'.

I just watched it take 100% of a CPU here and then back back down. In checking the .config file, can anyone enlighten me on these two parameters?


I'm assuming 'timer' is how often it checks and that it is defined in seconds - is that correct? What is 'res'?

ketfos wrote:Datastage doesnot support Oracle datatype Long?? Is it correct??

Not natively. They are accessed as large varchars, typically. Hence my questions about the specifics of what they are doing.

"2002156817161-1" isn't a number.

"2002156817161" is.
"20021568171611" is.

Would either of those work in your database?

Folks here didn't export projects because they always failed after a number of jobs. The reason was the were too big for datastage to handle (500+ jobs) or the job where it failed on contained double names for the links. The solution is to search and destroy that double naming and to export by cate...

Heck of a coincidence, don't you think? I'm not saying you intentionally changed anything, but from what I remember of the little bit of Access stuff I've done in the past, it will try to convert (or 'upgrade') an mdb from an older version to your current version when you try to open it. No clue if ...

Post your code.

I would guess that you've somehow altered or upgraded or in some way changed the .mdb such that it is no longer usable. I personally would have made of copy of it and then played with the copy, not the original... but then they do say that hindsight is 20/20.

Any chance you have backup?

No, can't say that I have. The target table doesn't have any fields defined as LONG, just large VARCHARs when you get this message?

I'd also be curious how you are doing your loading. What stages are you using? It might help if you describe how your job is laid out.

It is. I've had one or two jobs in the last couple of years where I was "forced" to change a password from Encrypted to String, otherwise I was only able to use the original default value. Any attempt to change it via the Director would result in the 'null password' error noted earlier. BTW, it's st...

ogmios wrote:Personally I like mule as e-mail client for these kind of things.

Or mutt but I can't get them to install it here.

Or that! I tend to forget about that.