DSXchange

One of the posts suggested using BASIC transformer to get byte length. I see LENDP function but the mapname argument is not optional in 8.x. What value should I specify to find out byte length(display length) for UTF-8? UTF8 is giving error, looks like it accepts some numeric value. Please guide wha...

Hi, We have few multi-byte columns. The field length(in terms of number of characters) is fixed. e.g., Address cannot be more than 5 character length but it can contain German special chracters(umlaut) in which case it might be more than 5 byte length. Inorder to maintain same position for each fiel...

Thanks for the reply. But the receiving system will have difficulty - because of some error if header/trailer is not sent then they will not know how many records were supposed to come and also that will be kind of indefinite wait right! The main challenge I am having is with the sequence number. In...

Hi, We send MQ messages. The receiving system has limitation on the size of MQ message to receive, so if the message size is huge then we need to break messages and send them. The file sent contains header(1st record), data records and trailer(last record). If the message has to be broken because of...

Thanks Ray.

TimeFromMidnightSeconds() is giving the right value.

Regards,
ssunda.

Hi Ray, I tried using StringToTime and TimeToString functions with the following syntax: date1=StringToTime(input,"%hh%nn%ss") output=TimeToString(date1,"%hh:%nn:%ss") For input value 065535 , the above functions result is given below date1:065535 output:06:55:35 But I want the o...

Hi All, I searched the forum but did not get required information. Iam getting a time value from input file. (e.g., 065535). In the server job, the function Oconv(columnname,"MTS") is being used and the output corresponding value is 18:12:15 Now we are implementing the same as parallel job...

Hi Ray,

Thanks for the reply.
I was worried since it is a parallel job but your answer has cleared my doubt now.
And I forgot mentioning that when using 3 transformers and funnel, I am using a remove duplicates stage. So I will not be getting 3 copies of data.

Thanks again.
Ssunda.

Hi All, My job requirement is to check if job activities of employees are proper. For example, His/her first task should be a particular job code and not 'OUT or Lunch'. The last task is always 'OUT'. And lot more conditions. To implement this After reading from the file in a parallel job, if I sort...

Ray, Yes, sometimes we delete, copy/paste job activities for similar jobs and then change properties. We have observed that when a particular job activity stage is deleted and copied again, it is not getting populated in the 'dependencies' tab. But truely speaking even after modifications, the depen...

Hi, We just found why dssearch was giving incorrect results. 'dssearch' command is listing only those job names which are present in the 'dependencies' tab in the sequence job properties. When we manually added the missing job names in the 'dependencies' tab, dssearch command listed all job names co...

Hi, I am using 'dssearch' command in a shell script to list the jobs/sub sequences under each sequence and then capturing the logs of those jobs. But for a particular sequence , dssearch command did not return the total list of jobs under it. There are actually 6 jobs in the sequence along with some...

Hi All, I am not able to login to datastage designer. When I give the required Id and password, it shows an error " Failed to connect to Host. The Connection has timed out(81015)". Please let me know if someone has faced similar kind of issue and also the reason's and resolution for the sa...

Got it Chulett. Nothing has changed actually. But now, Iam able to run the job again properly. I think there was some space problem.

Got it Chulett. Nothing has changed actually. But now, Iam able to run the job again properly. I think there was some space problem.