DSXchange

Not exactly what you're looking for... but you can highlight multiple columns and choose "Derivation Substitution..." from the right-click menu. A definite productivity help when doing repetitive derivations. Mike Thanks but that is exactly what i am not looking for. I know how to do that...

I need a generic cleansing functionality. It sounds like this: When the field value is empty or Null then if it is an Alphanumeric (Varchar and such) field then default it to Null, if it is numeric field, then default it to zero. It is easy to code, but I do not want to code it for every field in ev...

I would suggest to look at hex value this character using od -cx UNIX command or in any text editor that allow to see hex value (I usually use Ultraedit). Then match it to decimal It may not be 255. Sometimes the screen displays this character for other unprintable hex values.

Got it finally. It is actually with squre brckets
L_MOD_DATE:Date = date_from_ustring ["%mm-%dd-%yyyy"] (L_MOD_DATE)

Usually squre brckets used to denote optional parameters, here it is both.
The date format is either optional (with default format yyyy-mm-dd) or actully in square brackets.

I am having very hard time with modify: Lots. See Orchestrate Operators manual, ustring_from_date[date_format](date) Tried L_MOD_DATE:Date = date_from_ustring "%yyyy-%mm-%dd" (L_MOD_DATE) Got runtime abort with message: main_program: Error parsing modify adapter: Expected ';' or end, got: ...

Hello Gurus, I created a New Project and would like to copy User defined Environment Variable from other project. As Ray said i copied last lines in DSParams file and past in New Project. It did not work for me. DO we need to restart the server? or do i need to do anything else Appreciate your Help...

Does anybody know how to call ODBC from BASIC routine? I need to connect and query SQL server from Linux to do some housekeeping tasks in batch. We are migrating from Windows. On Windows we used OS call to osql wrapped in DS routine. So far we can't find a similar executable on Linux. My thought is ...

I need to move server jobs from DS 7.5.1 without PX(EE) on Windows to DS 8.01 with PX on Linux. We are using a lot of environment variables. In the past I used environment transport program, but that was between DS 7.5 projects. Is there anything similar for the conversion that I am doing now? I can...

ray.wurlod wrote:Moderator: please move to parallel forum

I respectfully disagree.
This question may belong to any of two forums.
But I am moving it in hope to get an answer, not just reprimand.

I need to move server jobs from DS 7.5.1 without PX(EE) on Windows to DS 8.01 with PX on Linux. We are using a lot of environment variables. In the past I used environment transport program, but that was between DS 7.5 projects. Is there anything similar for the conversion that I am doing now? I can...

We are migrating DS Server jobs from Windows to Linux.
Does anybody know the existing utility that will convert all the OS related settings in DS job (like \ to / and others)?
I am considering writing something myself.
I would appreciate any info on the existing conversion applications.
Thanks.

leomauer, After I re-read your notes, I was wondering why you want to utilize the Table Definition of the DataStage to profile the seqential files? Thanks for the sample. That exactly means what IBM person told us: there need to be as many entries into QETXT.INI file as there are files to profile. ...

The problem is that when you import a table definition into DataStage first you cannot use it in Info Analyzer - unless you use the Connector import from the Designer Import menu. The correct procedure is to import the table into Info Analyzer via the connector, profile it and then use that as a ta...

leomauer, You need only 1 entry in .odbc.ini and 1 QETXT.INI file for all of your sequential files. Of course, you must populate all the names and field descriptions of the sequential files. It's a pain. After that, all you can do on the sequential files is Column Analysis. Thanks lstsaur. Can you ...

We did connect to the file the way this IBM person described. I would like to continue this discussion. 1. I still would like to know if the Table definition layout can be associated with flat file. To reiterate: I have a file and I have a table definition for this file entered into Analyzer project...