DSXchange

More information about my problem.... - We dont delete this HashedFile and we dont wanted to delete it ! Its the reason why we have only checked the "Clear file before udpate". - DataStage 4.2 running on Unix (Solaris) Its make me crazy.... Ben pavan.marpaka@ascentialso ftware.com To: Benoit_Murray@...

Im trying to use the folder stage in DataStage 5.2/Windows 2000 and Im getting this error:

P01StagePayment2..Folder20.: DSD_DIROpen Folder Stage output link cannot have more than 2 columns.

Any help would be greatly appreciated...

you can also check the "Delete File" option under the "Options" button in the hash file stage (assuming you also checked the "create file" option), so the file will be delete and re-created every time you run the job. this is not optimal for performance though. -----Original Message----- From: Benoi...

you can also delete the hash file in a Before Job subroutine or in the Job Control section first. Check to see if the file exists and delete it. Or Change the job to only do a clear-file. good luck himanshu ----- Original Message ----- From: To: Sent: Wednesday, October 16, 2002 4:48 PM Subject: Err...

You cant create the file once its already been created. If you have a create-file set, then somewhere along the line there must be a delete file. Otherwise, once the file is created, youll need to change the job to only perform a clear-file and remove the create option. ----- Original Message ----- ...

Hi all, We have a intermittent problem with a simple job who created a Hashed File from Oracle table (OCI) and we cannot reproduce the error ... its intermittent. Here is the job : ************************************************************************ ============== ============== | OCI | =====>| ...

I wish to pipe the output of an external program into a DataStage job (under Unix). How do I specify standard input (stdin) in the sequential file stage? I tried stdin but datastage is looking for a file of that name rather than using the pipe. Am I missing some punctuation in the name?

Stage variable expressions are executed in the order they appear, much like any series of program statements. Simply put the evaluations (checking for differences) before the variable values are assigned. The variables will contain the previous value when you execute the evaluations. -----Original M...

Hello Riccardo, First, thanks for your suggestion. I assume using stage variable to store input fields for comparison. But how do I reset them when jiflag or statusflag changes so they can be checked against next input record again. In my case, initial value will be ji(A) and status(P) set by 1st re...

The biggest problem that I will have using the matches command is that my dates have come in: YYYYMMDD MMDDYYYY and even DDMMYYYY as well as many other formats: YYYY-MM-DD, MM-YYY-DD, etc. I have enhanced the "DateGenericToTimeStamp" routine to accomplish my date validation. Along with standardizing...

At 11:53 AM 10/16/02 +0200, you wrote: >Hi all, > >Does anyone know how this function works ? >Its the function to round off numbers with comas. The BASIC FIX() function essentially will either round off or truncate a value at a specific number of fractional digits or precision. So, for example: FIX...

Hi, try to use SEEK, it is described in "Datastage BASIC Guide" manual. Regards, Riccardo ----- Original Message ----- From: To: Sent: Wednesday, October 16, 2002 9:19 AM Subject: Appending to a sequential file > Hi Guys > > I have a sequential file Im writing out to using a routine. I have several ...

Hi Guys I have a sequential file Im writing out to using a routine. I have several input files I want to append to this file. However, everytime I issue an OpenSeq, for the next input file, the pointer starts from position 1 and overwrites what is already in the file. I have tried to do a readseq lo...

Try something like.... IF MYDATE MATCHES YYYMMDD THEN NEWDATE = MYDATE ELSE ...... good luck ----- Original Message ----- From: To: Sent: Tuesday, October 15, 2002 6:20 PM Subject: Date Format Check > > Hello All, > > I need to check input date fields to ensure that they match the > corporate > stan...

try MATCHES tim_walsh@na.dole.com wrote: >Hello All, > >I need to check input date fields to ensure that they match the >corporate >standard: YYYYMMDD. > >Is their a DS transform or routine that checks to see if a date is in a >valid date format? Ive looked at: >DateGenericIsDate - Only tells you if...