DSXchange

Hi, I have a job with a Column import stage ; in this stage a schema file is defining and i want to reject lines having more or less than 280 bytes My problem is : when the line is less than 280, the line is rejected (option Output in Column import Stage) but if the line is more than 280 caracters, ...

We do this, but not using Datastage. With sqlloader it's easy to do that.

Hi, I want to import a dsx file in command line on the server. it's seems that only dssh command can do that (Datastage 8.7) I use the oacvb's script ( http://www.dsxchange.com/viewtopic.php?t=133337&highlight=dssh ), but it doesn't work. I have : Verb "DS_IMPORTDSX" is not in your VOC...

Hi, I encounter the following error message [IIS-CONN-TERA-005057] RDBMS code 2794 in error table 2 (CC_TeraAdapter::selectUpdateErrorTable2, file CC_TeraAdapter.cpp, line 7,883) The database is Teradata version 12. The loading is a Bulk. The job run in production but can failed sometimes. Very stra...

Have you tried searching here for the error message that comes with that code? It has been explained many many times. ... It's very very funny. Of course I searched in the forum. I found all the threads. Even, I found a thread post in 2004 june 10th. The response was pretty similar. I know that the...

Hi, I have a problem I am unable to explain. I developped 4 jobs sequence. They started together, at the same second. Recently, the jobs finished aborted with a code 14 (ressource problem). (jobs run ok 2 days ago) If I run the job sequence one at a time, all finished ok. So my questions are : 1- Wh...

1. If database connection fails due to some reason and the rows cannot be inserted in TB_01 The job gets aborted. You have to catch the status of the job. And think about a restartable sequencer 2. If the table gets locked and the rows cannot be inserted in TB_01 Same thing, think about restartable ...

The view data stage rarely gets multibyte or non LATIN-1 characters displayed correctly and shouldn't be used to see if NLS is working as expected. In your case the PEEK result is strange as the e-acute shouldn't get converted to 3 characters. What is your job's default NLS setting and if you write...

1- check that your column have the same format in your 2 inputs integer must join and integer and a varchar join a varchar 2-check your partitionning and your sorts. you're are right if the partitionning and the sort are the same of the join key and in the same order 3- Insert copy before your input...

In my opinion there is no better file format.
Both can be used.

my preference goes to delimited format. the debugging is easier.

bart

I forgot
First, duplicate the data with copy and make a inner join between the filter output and the duplicate flow





---> copy --->Sort --->Agregate ---->Filter------|
..........|--------------------------------------------- Join------>

something like that. Adaptate as you want.

sort by col1,col2,col3
agregate by col1,col2,col3 with count rows
filter : 2 output links count>1 and count=1 to separate data

Hi Friends Below warning is giving problem to my job can any one give suggestion """APT_CombinedOperatorController(0),0: Field 'MBPUIT' from input dataset '0' is NULL. Record dropped."" but this field have data and lookup field also have data I given this condition in Trans...

No worries, you wouldn't want to see my French. :wink: The example helps alot. So... does this problem seem to be coming directly from the Sequential File stage itself or is it being introduced in later processing, say the 'remove duplicates' step you mentioned? I've seen posts about odd problems w...

you have the Num function. It returns 1 if it's a number.