DSXchange

Charles This can be done with some experimentation. The ServerEngine is the main account for Universe. Universe is the database that runs DataStage. This account is called the UV account. If you telnet into UV and LOGTO ProjectName or LOGTO F:ProjectPath then just run UPDATE.ACCOUNT. This will fix t...

Jennifer, Without knowing your XML schema I can just tell you that you need a Sequential File stage going to a transform stage going to an XML Writer stage. In the XML writer stage in the column definition screen, besides defining the field itself in the description column you have to enter where in...

Its doable, but very tricky. I would strongly suggest getting expert help, perhaps from Ascential. Your main problem is that the system tables that describe what is in the projects were in the Engine (or ServerEngine) directory on drive C, which you have removed. Therefore the system tables will nee...

Hi, Data stage has been uninstalled from a server machine c: drive , however the projects are in different f:. As you know when open Data stage Admin the projects are not listed in the drop down box in the first logon screen . Is I any way I can load the project into data stage repository (there is ...

Does anyone know how to convert a delimited output file into XML format in Datastage 5.2?

Thanks.

Hi, Does anyone know how to do a multi keyed hash file lookup in basic? I can use something like this to look up from a single key column: OPEN "xrec_hash" TO H else call DSLogInfo(cant open ascii_hash_lookup,) abort END READ REC FROM H,LookupKey ELSE CALL DSLogInfo(CANT READ REC :LookupKey,) RETURN...

Hello If you need to pass parameters down to UNIX or even create a complex UNIX command, its best to build up the string in basic and then call DSExecute with the string. e.g. S = ls -ail|grep xml call DSExecute(unix,S,o1,o2) call DSLogInfo(o1,o2) Here, o1 will contain the UNIX return code, i.e. 0 i...

Hi, while importing table definitions, click on plug-in meta data definitions, then after entering the server name, UserID and Password, click on next, then there is a option fully qualified name, un-check that out, then it will import only the Table name, not any prefix on it. thanks Reddy -----Ori...

You can always try renaming it once its inside Manager. That may work for you. ----- Original Message ----- From: "Pelletier, Christian" To: Sent: Wednesday, October 09, 2002 2:01 PM Subject: Importing SQL Server table definition in Manager > Hi All! > > Is there a way to tell DataStage not to impor...

Hi All! Is there a way to tell DataStage not to import the full qualifed name for a table? I would like to import only the name of the table -> person_job.trans_date , not the full string-> C_RAD_CAD_001.dbo.person_job.trans_date Thanks Christian Pelletier Sr. Engineer Probusiness Phone: 1-925-737-7...

Hi This in correct definitely use static hash tables, also when connecting to a database source use the native connectivity over ODBC where possible. It is also a good idea to trim varchar fields and depending on the file system used cached writes can sometimes improve performance. Simon. >From: Rui...

Hi Nuno, you can optimize the hash-file, to get a better performance, you must defined your hash as dynamic/static, size of groups, splits, etc. This way you get the better definition of your hash, getting a better time to load your data. Rui Soares Rui Miguel Soares NOVABASE - Business Intelligence...

Hi all, I have a job that creates a hashfileA based on a select statement on TableA: TableA ---------------------------------->HashFileA (the keys columns are key1, key2, key3) select key1,key2,key3,sum(value1), sum(valu2) from TableA group by key1, key2, key3; The HasfileA creation takes 1h30m to l...

Known bug. DS 5.1 command stage cannot use parameters in the command area, only parameters. If youre parameterizing the directory path to a command, youll have to hard code it for now. The alternative is to use a symbolic link but hard code that link. It will at least give you the flexibility to poi...

Hi all,

How can I pass job parameter through ExecuteCommand stage in Job Sequencer? For example, EXAMPLE.sh need 2 parameters then Im setting up the stage like this.

Command: EXAMPLE.sh
Parameters: #YEAR# #MONTH#