DSXchange

I am trying to count the of days between the Transaction date and the date posted. What is the correct syntax for the modify stage.


NumofDays = DaysSinceFromDate (DatePosted,TransDate)

Thanks.

OK they are separate issues. The problem sqlldr is having is that it can not open the file in the .\pipe folder. Verify that the executing user (the sqlldr identity) has sufficient permission to the pipe folder in the project folder and/or write permission to the project folder itself (so that it c...

SQL*Loader: Release 10.2.0.1.0 - Production on Wed Feb 14 16:59:46 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Control File: ora.376.390000d.0.ctl Data File: \\.\pipe\ora.376.390000d.fifo.0 File processing option string: "FIX 6" Bad File: ora.376.390000d.0.log.bad Discard F...

DataStage Job 7 Phantom 3200 3 record(s) selected to SELECT list #1. Program "DSD.OshRun": Line 1306, Unable to unlink the operating system file "DOS_61155_14290". Program "DSD.OshRun": Line 1319, Unable to unlink the operating system file "DSD.OshMonitor_61156_142...

Hi All, Oracle Enterpise stage Database 10g is giving this error. SQL*Loader-500: Unable to open file (\\.\pipe\ora.376.390000d.fifo.0) SQL*Loader-554: error opening file SQL*Loader-509: System error: The operation completed successfully. SQL*Loader-2026: the load was aborted because SQL Loader cann...

[Have you ever gotton this error message before with a job using a transformer stage?What compiler do you have installed] First time trying to compile. The version is 1.01.0000. [/If you make it "right" (either by editing ints.h or making a copy of strstream_s.h called strstream.h or strst...

Hi All, While compiling the transformer (simple job) I am getting ##E TBLD 000000 15:43:11(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 512 ##I TBLD 000000 15:43:11(003) <main_program> Error when checking composite operator: Output from subpr...

Have you read through all of that? Did you find an error anywhere in it? If so, what means have you tried to resolve your problem? Do you have runtime propagation (RCP) enabled? This is the error posted at the top as below. If I was able to resolve then why do I post it here. RCP is enabled. ______...

Hi I have simple job reading a sequesntial file and the Basic Transformer passing 1 out of 2 cols in to sequesntial file. I am getting error as below. Appreciate any help. BASIC_Transformer_10: Wrapper: t..BASIC_Transformer_10.DSLink3-Input [sil\step_il.C:646] Wrapper: -o0 [sil\step_il.C:646] Wrappe...

ray.wurlod wrote:Doesn't Search work for you?

Already searched before posting, but could not find any solution except installing C++ 1st and then install DS, which I already did but did not work.

Thanks.

Hi I am getting ##E TBLD 000000 14:03:21(000) <main_program> Subprocess command failed with exit status 256 ##W TFCP 000000 14:03:21(001) <transform> The number of reject datasets "0"is less than the number of input datasets "1". ##W TBLD 000000 14:03:21(002) <main_program> Outpu...

Appreciate if any one can share the orchdbadmin documentation.

Thanks.

hi all, how to create and generate a customized report after the job has run successfully Thanks in Advance Boppana Ramakrishna I would like to add 2 more qtns to this post. 1. How can we get all the job log entries including Score & Osh, errors etc from the Director in to one single file? I am...

Avishek Mukherjee, Appreciate if you can share the unix code in a generic way. Thanks. Another way which I have implemented is by file watcher concept using two unix daemon scripts. A Unix daemon checks for new files say in a Inbox directory. It compares file size to check if transfer is done. then ...

After removing the quotes in the source and retyping the derivation (Field(InLink.RecIn, ",", 2) it worked.

Thank you all.