DSXchange

At release 6 and perhaps early 7, the collector performed blocking reads. If an input link stopped supplying rows, or was delayed until the timeout was reached, then everything hangs. If your number of rows is relatively close, I have been able to make this work, too. Which version of 7 are you usi...

Do the two sequential files have the same number of rows. If not, I think this is a problem for the collector prior to version 7.5. As of now, both the sequential files have different number of rows. But why do you think there would be a problem if there are same no. of rows in both the sequential ...

Hi all, I have a job that is designed as follows Merge Stage--->XFM--->Seq File1.1---- | | |---Link Coll--> XFM -----> O/P file | ODBC Stage--->XFM--->Seq File2.1---- Still works well. I though I could replace Seq File1.1 and Seq File2.1 with IPC stage. But when I did that the link with Seq File2.1 ...

PilotBaha wrote:Any chance they can deliver this file to you in comma delimited text format?

nope.

I was hoping that they could send me the dates as varchar field format instead of date format. But my request is still under review.

thanks ray. But sadly i am still unable to get the ODBC stage to read the valid date values. Given below is the issue. In another of my source excel files I have a similar date field but the only difference being the first couple of records have blank date values (the format was still *3/14/2001). T...

I have an excel source file with a Date field of the format *3/14/2001. the explanation on * is that "Date Formats display date and time serial numbers as date values. Except for items that have an (*), applied formats do not switch date orders with the operating system." The date value as...

Hi, when you'll know this what do you want to do with this info? what will happen when a new version comes out and this info is no longer correct? DSGetJobInfo will be maintained for you but not your own custom design. if you insist you can always put a trace and hack it thru but I'm not all for th...

Hi,

I would like to know the universe table/hash file and its definition that would give me the final status of the job, the same info that the DSGetJobInfo would give me for the following Info types; DSJ.JOBSTATUS, DSJ.JOBSTARTTIMESTAMP, DSJ.JOBLASTTIMESTAMP.
Is it RT_STATUSnn?

thanks

Here is the first version of the routine that would get the latest log details for a specific job, and write the log desc. for any warning / fatal errors onto a sequential file (logfile.txt) The main changes that were done to Kim's KgdGetLastWarning(JobName) are made bold. And once again thanks to K...

You should just read the '//JOB.STARTED.NO' record and place the value in the SELECT statement. open 'RT_LOG1' to RtLog else call DsLogWarn() end read RtLogRec from RtLog, '//JOB.STARTED.NO' else RtLogRec = 0 end StartNo = RtLogRec<1> Cmd = 'SSELECT RT_LOG':JobNo:' WITH @ID >= ':StartNo:' BY TIMEST...

In BASIC there are 2 types of SELECT statements. One is a SQL SELECT. It has to end with a semicolon ";". The other has a syntax which does resemble a SQL statement. It has the form: SELECT MyHashFile WITH field = "VALUE" AND WITH field2 = "VALUE" fieldlist BY field1 B...

The Code is as follows * ----------------------------------------------------------------- * KgdGetLastWarning(JobName) * Decription: Get last warning. * Written by: Kim Duke * ----------------------------------------------------------------- * Notes: * ----------------------------------------------...

Stuck again! :( 1. My query SELECT SEVERITY, TIMESTAMP, FULL.TEXT, WAVE.NO, User FROM RT_LOG1 WHERE EVAL "@ID" NOT LIKE "//%" AND @ID > CAST(EVAL "FIELD(TRANS('RT_LOG1','//JOB.STARTED.NO',1,'X'), @SVM, 1)"AS DECIMAL) order by TIMESTAMP returns 28 records when run in the...

The last post was unclear about what I had commented. So here it is again

I commented the statements of the KgdGetLastWarning(JobName) routine which were setting @ID, @RECORD and @RECCOUNT. Executed the routine again. I did not find any difference. Is there anything I am missing?

Thanks

Sonia

Hi, thanks for the SQL. I tried commenting the running the routine again. I did not find any difference in the original output and the output after commenting. So still its unclear to me what is gained by setting @ID, @records and @recordcount There are some dictionary items which require @ID, @RECO...