DSXchange

Hi all, I am using the below unix script is it possible to call DS functions in the script. Please guide me on this. #! /usr/bin/ksh # Load into od_trans_map_output table for HALO Transaction Mapping #$INCLUDE DSINCLUDE JOBCONTROL.H echo $1 $2 $3 $4 $5 $6 isql -U$4 -P$5 -S$2 <<-EOI1 use $3 go trunc...

Do you get any warnings in the director? Something related to records getting dropped?

Since your server runs on Unix, may I suggest a UNIX approach? Something like a shell script that queries the dsjob -log and dsjob -logdetail and parses the previous run's log to determine the status of the previous run could satisfy your requirements. I once did this (wrote a shell function to find...

And why so CAPS LOCK??

[/i]

ravi_etl wrote:Hi,

I have a file to process that file has a filename as filename_date.csv
I need to pass that date in the job is there anyway to do this.
If so please let me know.


Thanks

Do you need to parse out the date from the filename? You want to do that using a sequence? job? or script?

DSRajesh wrote:Hi

I am unable to connect with oracle10gr2 version database using plug in oraoci9.

i am getting ora error tns doe not identify the service connected.

regards
rajesh

Are you using special characters in your password?

Have you tried to check the NLS between the DS server and the DataBase?

$DSHOME usually be loaded into your environment. Are you using AIX? Try

Hi, I want to delete it after performing a test on the reject link.I should use a stage do delete the dataset. If you want to delete it programatically use this command in a command stage in sequence / after job subroutine. $DSHOME/bin/orchadmin rm <datasetname> where $DSHOME is the home directory ...

I think we ended up manually changing the data on output in a buildop (a transform would work, too). I believe there is a system parameter (a APT_?? variable?) that can be used to set the DataStage code page, but while we have talked about it, we have not done this so I have no specifics. Brad. Hey...

I think we ended up manually changing the data on output in a buildop (a transform would work, too). I believe there is a system parameter (a APT_?? variable?) that can be used to set the DataStage code page, but while we have talked about it, we have not done this so I have no specifics. Brad. Hmm...

Found the reference, in fact I posted in back in April: EBCDIC ! and ] not translated properly The IBM site is posted there towards the bottom. It shows that code pages 037 and 500 map 4F to '|' and '!', respectively, and to 5A to '!' and ']', respectively. Hope this helps. Brad. Brad, Thanks a lot...

Hi, I have this simple job where I pull data from TeraData source and load into a complex flat file. Now the job works flawlessly except when a '!" character is encountered in the source columns, When incoming varchar source column contains '!' character; it seems that it automatically gets tra...

Another quick check : Please reconfirm if you are connecting to the same database while firing the query on TOAD and DS.

I burnt my fingers once ...

How about you tell us what you get on the reject link from the CFF stage? ... Okay let me paraphrase so that my dilemma becomes clearer. I have a source CFF (with EBCDIC Fixed length data) and I rout the reject link into a column restructure sage and convert the varbinay input into a varchar output...

vrishabhsagar wrote:

ray.wurlod wrote:I would expect to see all these rows in the reject file. You have declared three fields (999., XXX. and XXX.) but the "good" data have more fields than three. ...

Oh.. Very sorry... The original structure was 999,XXX,XXX and XXX.

Anyone has any ideas? Kindly help me with this....