Search found 22 matches

by Tornquist
Wed Jun 05, 2013 8:18 am
Forum: General
Topic: UserVariables Activity - PassLastSyncDate
Replies: 8
Views: 3752

Done. Thanks again for all of your help.
by Tornquist
Wed Jun 05, 2013 8:05 am
Forum: General
Topic: UserVariables Activity - PassLastSyncDate
Replies: 8
Views: 3752

Yes, that information was very useful. I had read that thread before, but I had misunderstood some of the information. I am successfully passing information from one job to another. I have a few more questions but I can ask those in another thread if that is preferred. They relate to the ultimate us...
by Tornquist
Tue Jun 04, 2013 2:42 pm
Forum: General
Topic: UserVariables Activity - PassLastSyncDate
Replies: 8
Views: 3752

It's hard for me to tell if I've set it up correctly. This is what I've done: Sync_GetTime -- Server Stage Load_Date (Sequential File) -> Set_Stage_Variable (Transformer) -> Save_Backup (Sequential File) I have the final sequential file to keep the transformer happy. Within the transformer I have a ...
by Tornquist
Tue Jun 04, 2013 2:17 pm
Forum: General
Topic: UserVariables Activity - PassLastSyncDate
Replies: 8
Views: 3752

UserVariables Activity - PassLastSyncDate

I am trying to create a system to keep track of the last sync date of a table. All the fields in the table have a updated date field and I would like to filter the input based on those two dates instead of filtering after the database connector with a transformer. Because I would like to filter befo...
by Tornquist
Wed May 29, 2013 8:10 am
Forum: General
Topic: DataStage Parallel Routine -- Compile Location
Replies: 6
Views: 8251

I was slightly unclear. I am simply using Windows to transfer the logic between a UNIX virtual machine and the UNIX server. I understand that the compiled object is not movable between multiple systems though. Should I get gcc installed on the server, is the rest of my logic sound? I can use C, corr...
by Tornquist
Tue May 28, 2013 3:29 pm
Forum: General
Topic: DataStage Parallel Routine -- Compile Location
Replies: 6
Views: 8251

That's what I was afraid of. Is there any way to compile logic that will work on that machine from a different one?
by Tornquist
Tue May 28, 2013 2:55 pm
Forum: General
Topic: DataStage Parallel Routine -- Compile Location
Replies: 6
Views: 8251

DataStage Parallel Routine -- Compile Location

I am working on taking a column that has a date as well as some other assorted string values and converting that into a Julian Day so that I can use the date functions within DataStage. Right now I do not have anything more than the ability to copy files to the UNIX machine and use DataStage designe...