DSXchange

Hi,

Use the APT_STRING_PADCHAR environment variable with 0x20 in the job parameters and run the job. Let us know if that resolves the issue.

HTH
--Rich

Hi,

Use the GetEnvironment function and get rid of the $. It is not required. Do a search on GetEnvironment.

HTH
--Rich

Hi Vijay,

Where did you find @DAY?

You can use the ExecuteCommand stage to execute a unix command to find the Day and then use the output (Execute_Command_0.$CommandOutput) in the NestedCondition activity to find if it is Friday or not and then move on from there.

HTH
--Rich

Hi,

Search for handle_null.

HTH
--Rich

Hi Deepak, Your lookup stage should have 4 links altogether. 1. One input link 2. One reference link 3. One output link and 4. One reject link if you set the lookup failure condition to Reject. I think you have 2 reference links. Just click on the specific reject link and right click and change it t...

Hi Deepak, If the data is loaded as it should be why abort the job? In the join stage you cannot abort a job. Use the lookup stage and set the lookup fail property to abort. The transformer allows you to abort the job using the Abort after rows property. If the job does not fail why should the seque...

Hi, Remove the parameter mapping from the job activity and hard-code the paramter value at the job activity level. I hope it is a string. Make sure you do not mention any double quotes as you would in a transformer. If the above solution does not work try to reduce the size of the DB command i.e iss...

Hi, What is your director log showing. Does it show any warnings of records being dropped because of nullability. The metadata might be not null for all the columns from one stage to another but the value for one of the columns coming in can be null for which you have to do null handling. HTH --Rich

Hi, In the Teradata Multiload stage you would have mentioned all the temporary tables that Multiload uses during various phases of loading data into the table. 1. Drop all the tables (UV, ERR, LOG, WRK) 2. Issue this command from Teradata SQL Assistant (RELEASE MLOAD <Table_Name>) This should resolv...

Hi All, I have to use the loop functionality based on the number of records in a File. I used the ExecuteCommand activity with wc -l command. In the start loop, the loop type is Numeric. Start is 1, Step is 1 and End is #Execute_Command_0.$CommandOutput# I got the following error LoopingSeq..JobCont...

Hi RStone, Where is this error coming from? Giving additional info will help like specific Datastage version, flavor of unix and what stages you are using in your job. Is it coming from a DB then what is your DB. I have worked in VB before and "Item is out of bounds" is a very familiar err...

Hi Preethi, This can be done but you have to create a basic routine which should contain Basic code something like this and return the record count JobHandle = DSAttachJob(jobname,DSJ.ERRWARN) rowcount = DSGetLinkInfo(JobHandle,stagename,linkname,DSJ.LINKROWCOUNT) Do a search on Server Forum. It has...

Hi Videsh, How long are these jobs running for? Find out what is the Inactivity Timeout set in Datastage Administrator. Check if the jobs are running for a longer time than that specified in the Inactivity Timeout. Also do a search on DSJE. There are many error codes. Increasing the Inactivity Timeo...

Hi,

Do a search. I think this has been discussed before.

Iam not sure but from what I recall is, the specification should have the precision and scale like QT=QT[38,10].

HTH
--Rich

Hi Siva,

Create a Teradata table. Create a view based on the table and load the table instead.

Use the Teradata API stage. There were some issues with Teradata Enterprise stage at our site.

HTH
--Rich