DSXchange

You still have not described what is involved in "validate". Users will be submitting the metrics data in .CSV files. In our database, we have metrics data with the associated duration (weekly, monthly etc.) For each record of .CSV file, based on the metric name, we will arrive at the met...

Well, we will be getting the data in the form of .csv files for daily/weekly/monthly/quarterly/yearly reporting spans. In these files we will have reporting period start and reporting period end dates. Dates will be in the form of either 'MM/DD/YY HH:MI:SS' or 'MM/DD/CCYY HH:MI:SS'. And these dates ...

Hi, As part of validations in a job, I have written the following code in a routine. When I tested with 02/30/2008 or 02/31/2008, its returning 3 for RPEmonth and 1,2 for RPEdate respectively. RPEday = OConv(IConv(Field(ReportingPeriodEnd," ",1),"D/MDY[2,2,2]"),"DWB") R...

Wait a second - you have two Transformers and are attempting to share the same COMMON area between them? And, there's a passive stage between the two? I don't think this works anymore after 5.1 because of the introduction of row-buffering and inter-processing options Yes. We have two transformer st...

When I included the given debugging statements, I found 30 rows logged with Intermediate variables Reason = Status = CountFileOut is a Transform Function and is called in the constraints section of the Transformer stage, with input parameter "Command" value as 1 and with the OutputIndicato...

When I implemented the above mentioned logic in the CleanupFileOut routine, message logged was "(Debugging): FileOutRows is zero, Command is Erase "d:\smdpi\outbox\73434.20080112_154657.fileout.csv". However, when I slightly modified the code for CountFileOut routine to include log me...

! COUNT OUT FILE ROWS
If IsNull(OutputIndicator) Then
Status = @FALSE
End

Reason = Trim(Reason)
If Status Then
FileOutRows += 1
End

The above code of the routine - CountFileOut, increments the FileOutRows (which is a common variable) based on the not null value of OutputIndicator.

Ok. Job has the stages in the following sequence: ODBC stage (O1) --> Transf Stage (T1) --> Seq.File Stage (S1) --> Transf Stage (T2) --> ODBC Stage (O2) In stage T1, in the constraints section, included a routine "CountRowOut" to count the number of rows passing to the sequential file in ...

Hi, We are in the process of migrating DS 5.1 to 7.5. We have 5.1 jobs on one server and 7.5 jobs on the other server. When I process the data, it should create an .Out file on the server. However the file would be erased on the server, when there is no data in it. The "Erase" process is d...

I agree with you, but is there a work around for this issue?

That's probably because both the SQL CAE Access Group standards and the ODBC standards specify single-quoted string literals. How this issue needs to be handled? The same project is successfully running on Windows 2000 server, no warning messages & no insert fail statements at all. We are findi...

When I execute this query in Query analyzer, its throwing error. However, if I modify the double quotes around the strings with single quotes, its working. Is this anything to do with double quotes??

Hi, I am having an issue with one of the sub job in a controller job. Sub job is logging Warning messages as below. Its logging warning messages only but not causing any job abort. emailLoad..emailLoadProcess.emailLoad: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO survey_email(ema...

Could any one suggest the root cause for this issue. I am encountering this issue when the function has to return some speacial characters. However, if there are no special characters in the data, routine is working fine.

Any ideas?

Thanks,
Latha

try this:

first_part : char(034) : "Market" : char(034) : last_part

This has worked out. Thanks a lot.
But, how you could suggest this?

Thanks,
Latha