DSXchange

Hi, Yes you can combine PX and Server and I think that is the best solution. 1.I have set of validation on a flat file (record size) If the file is not big, go with server and execute them in parallel. 2.Removing duplicates Use PX with the Stage remove duplicate 3. Finding the new records modified a...

I tried but it doesn't give me the good result in a query. But if I use find , you are right Ray, I can use * but I have the condition 'Contains, Starts with, Ends with'. I do not have these operators in the query. Example for my parameter: Attribute : File Name Operator : = Criteria : Meta* When I ...

Yes, I tried it. I think I ask to Ascential.
I give you the answer when they will be resolving it.

Thank you Ray for your support,

Pey

I have no filter. - I create a new Import Category - I select Import/New - I choose DataStagev6 and I keep the default (Unattended Import checked). All is good but nothing on my screen. If I see the option Directory Versions, for my version, there is not filtered. I don't know, Halloween :evil: pass...

I understand nothing... I do an import from DataStage6 to MetaStage6. All is OK But I see nothing into my folder. I cannot move object into the folder User-defined Categories because it show no objects. When I execute a query, I have the good result. I already reinstall MetaStage on my computer, re-...

Hi, I created :P a query for retrieving all the Job Designs using the same Sequential File. I have one parameter : Filename. How can I do when I know only a part of my name? what is the syntaxe? For example : filename = FranceLost. In Sql, in can write like %France%. And in MetaStage? :cry: Best reg...

If you cannot, reinstall DataStage (10 min). That's faster.

Pey

I think, you have to modify your user profile on Unix. Like the message write, see with your Unix Administrator.

Pey

And Do not forgot to install (on your server) the compilator C for the active stage.

Pey

Thank you Amos,
I didn't think that It was so easy to do.

Pey

Hello,
I would like to get the lenght of a field and put the result in a binary field.

ex: Len(name), but when I do this the result is not in Binary format even if I define the field bin.

thank you.

Pey

Another possibility : check the field 'Position'. If you have a value, it's perhaps not the good one. So, you can supress this value. Personaly, I already put this field to blanck, like that I suppress a risk.

Pey

For Server, Ascential develop for us a Plug-in (TDMLOAD) which better then the Teradata Plug-in. For PX, I don't think that the Ascential Plug-in perform. All the extract or Load that we have to do, do with Server and After we read the file in PX. I know that Ascential try to develop us a better Plu...

You are right Teej, if you do a cut and paste (existing transform from server to transform PX).
Like that you can transform a Sewrver Job to a PX Job

Pey

Hi,
I know I can do that with Basic Code or In a routine.
But Is it possible to update dynamically, an Environnement variable that I have create.
For example : I do an extract and I want to keep the last value for the next execution.
I have create a variable $LASTVALUE.

Thank you

Pey