DSXchange

Its apples to oranges. Its a question of bytes/row. Parsing by fixed width is faster than by delimited only when the bytes/row is about the same. Fixed width pads the data, so a couple of columns of large width bloats the read operation. If you have a file with 10 columns, 4 of which are VARCHAR(255...

Hi All, I have a theory on the following problem we are experiencing.... but Im not sure that theory is reality. So, I thought I would check with the experts to see if my "guess" is correct. Problem: We are on NT 4.0, DataStage 5.1... We have a batch job called Batch::ContinualLoopJobScheduler that ...

Weve addressed this by setting up two new UNIX groups. One each for test/production. Then we assigned the users to the appropriate groups setting these to be the primary. Once the users are setup ensure the umask settings are such that it provides access to user and group only. Next you need to chan...

Hi Martin, you can let your UNIX administrator do it. If all files and all sub-directories of your test-directory dont have any accessrights for your developpers they cant access any of the Elements. Wolfgang > -----Original Message----- > From: Dahlfors M. (Martin) [mailto:Martin.Dahlfors@NL.Fortis...

Hi all My client requires two environments, development and test, to be on the same server. How can I restrict Development users from accessing projects in the Test environment? Ive heard that you can set the user groups in the file .developer.adm in the Datastage home directory, but does that just ...

Hi, I am prepared to produce a DS job process auditing report. It is supposed to include the following information for each job: Exception_ID - a unique generated key. Timestamp - the time the exception was found. Exception_Field - the name of the field that casued the exception Exception_Type - a c...

Greetings Tracey from Down Under We have been using the CFF plugin for a number of months now, under version 6.0, and have found it to be OK. I did report some bugs in the original version that came with 6.0, but Ascential have released an updated plug-in that fixed all my issues. If you check out t...

Why not import the table definition for DS_AUDIT into DataStage, then create a job using a UV stage to interrogate it? Observe the SQL that is generated. In particular, observe the SQL that is generated when you choose "normalize on MODS" from the drop-down list. But its pretty much standard SQL (th...

Surendra There is no describe command. To list the fields on a hash file: LIST DICT DS_AUDIT There are some fields which work for all hash files like F1, F2 ... F3 for fields 1, 2 and 3. These fields can be stored in 2 places DICT.DICT or the VOC. You can add fields ED DICT DS_AUDIT NewFieldName. Th...

Hi, I have the .PDF documentation for the CFF plug-in, but Im not in a position to run tests to answer my questions (Im still at DStage v4.1, and realize I need to get to v5.1 or greater before working with the CFF plug-in). Can anyone shed light on these questions? People preparing an EBCDIC data s...

Try LIST.DICT DS_AUDIT Pavan -----Original Message----- From: Surendranath Gujjala [mailto:Surendranath.Gujjala@Ingenix.com] Sent: Thursday, March 06, 2003 1:18 PM To: Datastagegroup (E-mail) Subject: Help on uv sql code Hi , Im having trouble with uv basic sql commands. I m querying on DS_AUDIT tab...

DS_AUDIT is a non-relational hash file that may not give you what you want. Unless you know the command line syntax for DataStages command line, youre going to have trouble understanding how DS_AUDIT is put together. To explain further, DataStages entire job design data model does not follow the rul...

Hi , Im having trouble with uv basic sql commands. I m querying on DS_AUDIT table, I like to know syntax for 1) Describing above ( desc or describe DS_AUDIT is not working) 2) finding the audit information for a particular JOB or routine in DS_AUDIT. Thanks in advance Surendra This e-mail, including...

The command is dsjob, its in the DataStage engines bin directory. Executed with no command line options, it provides a top-level syntax help. PATH=`cat /.dshome`/bin; export PATH dsjob ----- Original Message ----- From: Karthik.Kandamuri@awi.state.fl.us Date: Wed, 5 Mar 2003 19:37:29 -0500 To: datas...

Ciao Fabrizio, about your questions: > - whitch plug-in do i need to complete the library on server and on host? It depends on whats your goal. During the installation you can choose plug-in to install on your DS server by selecting them (or de-selecting). About the host, you have to install the mai...