DSXchange

Hi all,

is it possible to rename the job or a routine from Adminstrator using a SQL command? If not possible, other than a right click on job/routine, is there any way i can rename the job or routine?
This process is actually taking more than 10 min sometimes.

Hi all,

I have a job which loads the MQ and when I ran the job, I got a fatal error with reason codes 2035 and 2058 sometimes.

Now I want to know where can I find the elaborative description for these reason codes.

Thanks in advance!!!

Thanks for the reply, Kumar.
The datatype is Varchar. should I change the datatype?
length is 258Kb.

Hi all, I get this fatal error when I run my job: SQ_IN_01,0: Consumed more than 100000 bytes looking for record delimiter; aborting As specified in th error, in this input file, I have some records and each record occupies about 256KB of data and then comes the record delimiter, UNIX newline. Is th...

Hi, I have some xml messages in a folder on UNIX server and I want these files to be read by DataStage. 1.Can I use "File Pattern to read these files? Is there any limitation in the number of files read using the File Pattern Technique? 2.If File pattern can be used, suggest me some other idea ...

Hi all,

I would want to know how to pass a value from a UNIX script to DataStage job. Actually the UNIX script triggers this DS job and we have to have a value to be passed from the script to the job.

can anyone explain me how to do this.

Thanks in advance!!!

Hi all, I am loading millions of records into a SQL SERVER table. For each of the rejected record, I get an entry in the log and the log gets filled and creates problems, so I wanted to restrict the number of entries written to the log. Can you please tell me how to restrict this? Also, I am using a...

Hi all, I have a requirement which goes like this - A .txt file should be splitted (logically) based on the memory / size of the data and a hard coded value should be appended for each and every split and written into a output file. To explain it more clearly- The input file which is more than 256KB...

Now I have a new question in my mind, Is this BCP stage can b used on my UNIX based DataStage?

Thanks Ray! I have no idea, but when I click the "property help" option seen on the stage-> properties of BCP Load Stage, It says, when Loading into sybase,you have the choice of using either the sybase DBLIB client library or the CTLIB client library depending on what you have installed. ...

From this forum, i came to know that I can use a BCP Load Stage to do a Bulk Load on MS SQL SERVER DB. So, I created a server job to do a bulk load and I got this error - "nameof the job..name of the stage: Could not load dssybctl.so" In the client library column, I have used the default v...

Hi all, I got a new requirement which says : The input txt file from Unix box should be read by datastage and should be splitted in to multiple XML files based on the size of the data, for an eg., 256Kbytes. Is it possible to achieve this from datastge? If so, please let me know. Thanks in advance!!

Thanks for all your reply, I am telling a something which had happend when I ran the sequencer. The sequencer got aborted, because the Job2, which I have already specified had encountered a fatal error, due to space issue. My doubt was - As Job 2 failed, it should not trigger Job6 , but as other job...

Hi all, I have a doubt in the execution of jobs in the sequencer - I created one sequencer which has the following structure: Job1 ---> Job5 Job2 ---> Job6 Job3 ---> Job7 Job4 ---> Job8 Here Jobs 1 to 4 will run in parallel, independent to each other and Job 5 till 8 is based on the result of the pr...

Hi all, Let me explain the query again: It is related to loading data into a SQL SERVER DB table from the sequential file, not retriving the data from the table. Actually I use a Sequential file to load the table and this sequential file was inturn an ouput from a job, which runs in parallel and her...