DSXchange

Any suggestions..

Hi, I am getting the following error OpenLink][ODBC][Progress Server]Failure getting record lock on a record from table PUB.Client. when another online application has locked the table 'client' for update or delete. And this happens even when i read i.e even when i do select records from the table ...

Hi, I am getting the following error OpenLink][ODBC][Progress Server]Failure getting record lock on a record from table PUB.Client. when another online application has locked the table 'client' for update or delete. And this happens even when i read i.e even when i do select records from the table I...

You mean partition can never cause record locking when the constraints are mutually exclusive ? Putting 'same' at the very beginning and continuing with 'same' for the rest of the stages ..without applying any other partioning..will this lead to any errors... As per my understanding 'same' is faster...

Hi, I have a job which runs on 4 node configuration. It has a dataset followed by a transformer , the transformer routs the data to same table based on 3 different constrains. I hav'nt applied any partition on dataset and transformer. But for the three instences of table.. i have applied partition a...

Hi, I am working with ODBC stage to connect progress 4GL database. I am able to run a sequence in the 1 node configuration. But the same sequence is not running successfully in 4 node configuration. the sequence aborts at the 3rd job among the 3 jobs in the sequence. errors are: APT_CombinedOperator...

hi..

It s great if you can share the resolution with us.

Hi, I have a query regarding Indexes on coulmns of a table. if there are 8 columns in a table say col1,col2,col3,col4,col5,col6,col7,col8 and out of theses columns col1 , col2 , col3 together are indexed where all the three form a composite key. Now if we try to search for col1 only or col2 only ins...

The data is this way Case 1 ABCTTTAAAABBB ABCTTTAAAABBB ABCTTTAAAABBB ABCTTTAAAABBB | Case 2 ABCTTTAAAABBB ABCTTTAAAABBB ABCTTTAAAABBB ABCTTTAAAABBB| In both the case '|' is just to show you the position of the cursor in the file. case 1 do not throw this warning where as Case 2 throws warning Pleas...

Hi, I am trying to read a fixed width file .txt While reading when the file has a new line it do not give the warning Warning:Missing record delimiter "\n", saw EOF instead Else when the file has no newline at the end of the records it gives a ewarning Missing record delimiter "\n&quo...

Thanks a lot for the reply This resolved my issue.. Hi ranjini, In the excecute command activity stage in command give value as sh -c and in parameters give value as "cat filename" pass this value as a parameter to the next jobactivity stage for the desired job using the code . Field(EXC_R...

hi, How can we read anumeric value in a file which is the out put of job1 and has to be passed as a parameter to another job. I tried to use execute command stage with cat <filename> but it is giving an error as Controller problem: value not numeric (7) - cannot execute tried with NUM as well but ch...

Yes i have posted the whole error
It dint give any warning

ray.wurlod wrote:SQLConnect is the ODBC API function that connects to a data source.

There is usually more useful information than that. Have you posted all the error/warning information that was logged?

In the ...

This error comes when i tried to connect to the database through ODBC stage. And the userid and password are correct as it worked once. Hi , Could any one suggest where to look in to resolve this error message as this error comes and goes any time.. Fatal Error: Could not connect to datasourcereturn...

Hi ,

Could any one suggest where to look in to resolve this error message as this error comes and goes any time..


Fatal Error: Could not connect to datasourcereturn code -1 from SQLConnect(handle, infousr, ****, infodev) with message 523 92