DSXchange

bhaskarjha wrote:Hi,
Try using this
VALUES ( 9999 , 9009 , "2006-08-21 14:30:00.000000").

When I include the double-quotes I get an error-message stating that a unvalid token was found. Without the double-quotes it still states a syntax-error......

I do not know how you insert timestamp into hashtable. I just did a test, wrtie timestamp as string into hash file, the field data type is timestamp. There is no problem at all. the timestamp I am using is like this, yyyymmddhhmmss, for exsample 20060606124731 Can you send me the code of this test,...

Which database? The easiest is to use a CALL DSExecute(...) API to run a system command, such as sqlplus, isql, sqlcmd, dbaccess, etc. Just formulate the DML or use an existing script and invoke it using the command line program. Please don't do this to avoid using an ODBC/OCI stage for loading dat...

maybe that to mask or not to mask or to convert or not to convert is the hash files problem... Try to change the field-names "TIMESTAMP" and "TIME " as fieldname make my stomach turn a bid. Use "ErrorTimeStamp" and "ErrorTime" and tell if it helped. I have ch...

It is so much easier to make all the columns varchar on a hashed file. Deal with timestamps only when writing to a real table. I also tryed that. If it is defined as varchar then I get the following error-message: DataStage/SQL: syntax error. Unexpected symbol. Token was "2006-08-21 14:30"...

Hello,

I want to write directly to a SQL-database in a DS-routine. Does anyone have an example how to do this?

DeepakCorning wrote:I m little confused..When you say HashTable do you mean hashed File or a DB table?? So Job1 loads a tables and the Job2 Loads the file??

I mean a hashed file.

Hello, I am having trouble inserting a record into a hashtable with a routine. This record contains a field TIMESTAMP. I get an error-message on the data-type of this field. This is the actual error-message: DataStage/SQL: character and number types are incompatible in this operation Scanned command...

DeepakCorning wrote:If you are simultaneously triggering two jobs with the shared container in it then it will give the same error as they can write to the seq file at the same time. Try using Hashed File.

Why use a hash-file? Is it possible to read and write simultaneously from multiple jobs to a hash-file?

Hi, I have developed a shared container to add error-messages to a error-log (sequential-file). The name of the file is hard-coded. I use this container in several (upto 20) server-jobs. When I run the sequence with all these server-jobs running parallel at a certain moment the job fails with the fo...

Hello, Based on UtilityHashLookup I build a routine, but when I test the routine it fails to open the hashfile. I think I did not state the name and path of the hashfile correctly, but I do not know what I am doing wrong. I know that the pathname of the hashfile that I need is "c:\hash" an...

I have read your coding and I am trying to use it, but when I test the routine it fails to open the hashfile. I think I did not state the name and path of the hashfile correctly, but I do not know what I am doing wrong. I know that the pathname of the hashfile that I need is "c:\hash" and ...

How can I then retrieve the jobHandle of the next parent level? What is wrong in my code? My code: JobHandle = DSJ.ME Loop ParentJob = DSGetJobInfo(JobHandle,DSJ.JOBCONTROLLER) If ParentJob <> @NULL Then ParentJobHandle = DSAttachJob(ParentJob,DSJ.ERRFATAL) JobHandle = ParentJobHandle End Else Exit ...

Thanks for your response(s). I have build a function 'getUltimateParent' based on your response(s), but when I test it it doesn't seem to work correct. To debug the function I write the jobname(s) which are returned by DSGetJobInfo to a text-file. I have made a testcase of a job of 3 levels: Job_Lev...

I also tried the code below, but this code also did not work (the previous code did not work either): JobHandle = CurrentJob Loop ParentJob = DSGetJobInfo(JobHandle,DSJ.JOBCONTROLLER) If ParentJob <> @NULL Then ParentJobHandle = DSAttachJob(Parentjob,DSJ.ERRFATAL) JobHandle = ParentJobHandle DET = D...