DSXchange

Yes it does, that's why the question. See, I am running a wrapper script to read the schema from the dataset and create a mload script, which will pick data from a sequential file, which is supposed to have the same column structure. In my datastage job, I am assigning the same column structure to b...

Hi all, I am trying to use orchadmin command to read the schema of a dataset and using it to build a reusable component (wherein this script can be used for any dataset). However, the challenge I face right now is that the column list that shows up as a result of "orchadmin describe -s datasetn...

Dear All, We are using Datastage 8.5 in my project and I am facing an issue with a long running job for quite some time now. The job fetches data from a table (using TD Connector in Bulk Mode) and is writing to a lookup fileset. The query takes a little while for execution, but the results are fetch...

Dear All, I am finding a stragne behaviour with the datastage teradata connector stage. There's a source table having a decimal (18,3) column - whose data has to be direct-mapped to the target table whose same column is defined as DECIMAL (31,5). So my job has a TD connector stage followed by a tfm ...

Hi All, There is a datastage job we are using to fetch records from a source DB by using Teradata Connector stage (Bulk mode, invoking the Fast Export) and write it to a dataset - the volume is close to 32 million records (fetching data close to 25 GB) and the job takes close to 1 hour and 15 minute...

Thanks Siva. Your explanation of the problem seems relevant as when I specify the ITAG name as "bde" and specify a different port number, the installation program continues successfully. Yes, we had installed Information Server, but it was a hard-delete instead of a regular un-installation...

Hi All, I'm trying to install Information Server 8.5 on AIX platform, but getting an error during installation which says: Port 31538 is not available I did a netstat -an to grep out this port number, only to find out that this port is not bound to any application. If I change this port number to an...

This looks more like an Oracle error to me. You may refer the following link
http://www.dba-oracle.com/t_parallel_dm ... tected.htm

You may try running the query separately on Oracle to confirm the same.

Regards
Sriram

Hi All, I have an input column of Varchar datatype which can have two formats: ddmmyyyy or yyyymmdd. So to be able to process both types of records, I use the function If IsValidDate(StringToDate(StageVar, "%yyyy%mm%dd")) Then StringToDate(StageVar, "%yyyy%mm%dd") Else StringToDa...

Hi All, I have exposed a datastage job as a webservice using the ISD tool. But there seems to be a doubt with the usage of parameters in the datastage job. Since any job, when deployed as webservice, is continuosly running, and it is initiated by the ISD tool, how can we pass values for the paramete...

Hi All, I am using an external source stage which picks up XML files from a Unix location, and feeds data into an XML input stage. The command that I use in the external source stage Source Program field is as follows: ls #File_LOCATION#S* This works well as long as files are present. But if files a...

Hi,

Using we can set the warnings limit to 'n' warnings. Do we have any option to specify that warnings are unlimited, using dsjob command, that is.

Thanks & Regards,
Sriram

Thanks Ray. And apologies - I posted this in the wrong forum.

Regards,
Sriram

Hi, I created a parameter set named DataBase, and included five parameters inside it - SRC_USR, SRC_PWD, TGT_USR, TGT_PWD and SERVER. I created a file (database_par) out of it with default values, and it got stored by the name of database_par at the location ..Server/Projects/<ProjName>/ParameterSet...

Hi All, I need to expose a datastage job as a webservice. The functionality of the job is pretty simple - an input column A is fed to the webservice. Inside the job, I have a table with columns A and B, and I use a Join stage to fetch value in col B from the table, and output the column B. The job h...