DSXchange

I posted a script a while back that will get all the records of the same column value and filter those records into a file with the same name as the column value. You can search for it.

kumar_s wrote:I guess Ray should be more happy, as this is his favorite database, as I could recall from some of his previous post.

Thats true. I read some of his very earlier posts and he just loves RedBrick.

Most certainly. Maybe a generic routine could be created to handle all date and timestamp formats.

Sure you can. For dsjob command, its just another job.

A monitoring service should already be in place by your SA. Adhere to the purge settings, also make sure you archive temp files and delete them regularly.

Narasimha's design would be from a sequence job. Ray's reply would be for command line. You have both options now. Adapt, learn and shine
You can put something, probably an Execute Command Stage that just creates one file in the temp directory.

No Sam, this is just for the input shown by the OP. Because i am disecting the date and I know that the first part is going to be Month in three character string, the second part is Day and so on. It wont work for any input format.

Use the following C function to convert your input into YYYY-MM-DD 24HH:mm:ss.nnn format. THen use StringToTimestamp() to convert the string to timestamp. #include <stdio.h> #include <stdlib.h> #include <string.h> char* SybaseToOracleTp(char* InTp) { //Initialize variables const int SIZ...

DategenericToODBCTimestep() is a server function and not present in PX. You need to write a parsing C program to bring your input into a oracle format and then apply StringToTimestamp() function on it.

Look into sed. You can apply sed as a filter command.

Define a stage variable. That should calm down the compiler.

To get the contents, you can go to your project directory and do

jherr22 wrote:
Feb 10 2007 10:30:30:450AM

Do you have a space before AM?

Thats a good solution narasimha. Shrek7577, put narasimha's command (just the findstr /v /r "^$") in the filter command after enabling "Stage uses filter commands" in the sequential file stage. That will work for getting rid of the blank lines.

That looks fine to me. It has 17 columns which means 16 delimiters(;). Make sure your specifying ; as the delmiter. Also to take care of missing rows, go to the columns tab and for the first column specify YES to "Contains Terminators". This will enable the stage to read the file. In the constraint ...