DSXchange

DSguru2B

You should be able to change its setting in dsenv file. Cant remember what variable. Do you have any entry in dsenv file that is pointing to your interface file?

DSguru2B

It should. Someone here needs to confirm that as I am not sitting on a windoze box.

DSguru2B

For a flat file you can use the following. File is the input argument that will be the fully qualified name of the file to be removed. FUNCTION RemoveFile(File) IF system (91) THEN OS="NT" CMD="del ":File END ELSE OS="UNIX" CMD="rm ":File END C...

DSguru2B

What if you change the date to character in the where predicate.
Just the where clause:

Code: Select all

WHERE 
TO_CHAR(SEND_DATE, 'YYYYMMDD') > '20060831' 
AND TO_CHAR(SEND_DATE, 'YYYYMMDD') <= '20070330'
AND Substr(act_code,3,1)<>'R' 
AND media <> 'Intranet'

DSguru2B

What is the log entry for after job subroutine? Are there any warning messages? Reset the job and see if any messages, "From Previous run..." show up in the log.

DSguru2B

Are you using ftp stage in your job design? Try searching on 'ftp_put'.

DSguru2B

Go for training maybe

?

DSguru2B

Dont let it happen again. Utilize the job log purge settings option. Dont let it grow too large.
If you exported your entire project to a new project, then you can drop the old project. This will ensure all hashed files are removed pertaining to logs.

DSguru2B

As noted, it should'nt be a problem, but your query seems vague. What exactly is your apprehension again?

DSguru2B

How good are your C skills? Writing a C function that will remove letters/digits is not hard. You will have to read the string, one character at a time, assign it to an integer variable which will store the character's ascii code. You can constraint ascii codes to integers and alphabets.

DSguru2B

Thanks guys for the kind words. Still aiming for the stars

DSguru2B

You can set Identity Insert On in OPEN statement and OFF in CLOSE statement. But that means that you will have to generate the keys and pass the key column in your insert. And no one else should load anything into that table at that time. I am not sure why your job is hanging. Get together with your...

DSguru2B

I bet the error message is for the target stage. What is the column you have defined in the target OCI stage? Does that table exist in the database? Does it have the column you are using? Are you using user defined sql in the target stage or generated, if generated then what is your update action?

DSguru2B

I did not pay much attention to that, my bad. My focus was stuck on the fact that the OP was not opening the fully pathed hashed file, just the hashed file name.

DSguru2B

chulett wrote:Ah... nothing like a little revisionist history.

You the man Craig.

Search found 6797 matches