DSXchange

chulett

StringToDate(IncomingCol, "%yyyy-%mm-%dd")

As balajisr implies in his example - you cannot include dashes in your date mask when your source data is not, in fact, delimited with dashes as well.

Code: Select all

StringToDate(IncomingCol,"%yyyy%mm%dd")

chulett

kaps wrote:I have also seen that the following message in the log even though I did not set up the shared cache in uvconfig file

That option is for System Cache not 'link private caching'.

chulett

roblew wrote:I do not see the stored procedure option in the "ODBC Enterprise" or "Stored Procedure" PX/EE stages.

What "stored procedure option" would you be looking for in the Stored Procedure stage?

chulett

There are plenty of times when Oracle is not in a position to honor anything like a 'stop request'. Typically, if the query is actively returning rows it can be gracefully stopped. Other times, as when a dataset is being 'readied' for one example, you can't - or at least not until it gets to an inte...

chulett

[this post intentionally left blank in deference to the requested Craig]

chulett

Officially, you'd need to do the second lookup in a second transformer since the GUI does not support cascading lookups like that. However, it will work fine if you hand-type the column in the Key Expression, in spite of the fact that it will remain red.

chulett

And to get everything externally pathed, suggest you use "rm -rf *YourHashedFilename" to get the Dictionary file as well.

chulett

I just wanted to make sure we were actually talking about the 'project' directory itself and not the 'Projects' directory that they all typically live under. There is no need to pre-create anything for this. I would guess however, since your new project works just fine, that you did not in fact inst...

chulett

You'd need to define what you mean by 'UNIX Project level directory' so we don't go on a wild goose chase. And in order for us to have a clue what steps you may have missed, you'd need to tell us what steps you followed first.

chulett

And these same 'IBM Professionals' not only didn't comment the code but also did not leave you any documentation for it? That's... unfortunate. No worries, it's a public forum and everyone is entitled to an opinion - however, there's really no place for "put up or shut up" comments. We're not really...

chulett

Pavan_Yelugula wrote:Unfortunetly This buildop is not coded my me and i don't have expertise on c++.

Then - in my humble opinion - you shouldn't be the one posting the issue. Either the original coder or someone who's taken over for them with the C++ experience needed to work with it. Would that be 'UPS'?

chulett

You can't. You'll need to build a different hashed file with the appropriate keys - based on Field2 and Field3.

chulett

Don't have that MF edition, but have you tried it yet? I would think you should be able to declare a job parameter and then reference it in your SQL just like in any other edition - enclosed in hash / pound signs. For example:

Code: Select all

where FieldA > #StartValue#

chulett

Of course it's 'reasonable'... as noted, people have done this before. What's important to understand is that DataStage has no native cluster / fail-over support so nothing about it would be any kind of transparent. I don't see why pretty much any application can't be made to fail over to another cl...

chulett

You never answered this question, so let's expand on it a little:

Does this only happen on your PC or does everyone have the problem? Does it matter what type of job you work on - Server or Sequence jobs - or does the job type not matter?

Search found 42189 matches