DSXchange

can non-key columns looked up?Pls give the reason for yes or no

Ray, Thanks for your response. I changed my hash file path to my own path and modify code in UtilityHashLookup to OpenPath rather than Open in the copy routine.But still i couldnt read value from hash file.Now error is 'record not found'.I couldnt find Trans() function in my repository.Please advice...

Hi, My requirement is to pass control table information(in sybase) which are updated regularly as job parameters at sequencer level. Parameters are fileformat, server name, pathnames, etc. I tried by creating hash file by using directory path lookup and using utilityhashlookup transform to get these...

Hi Folks,

I have a requirement to connect sybase database using DS routine. From there I need to get values from a table. which are passed to a job activity as parameters.

So can anybody tell me what is the option to connect to sybase database using DS routine.

Thanks in advance.

Hi DSxians, I have a sequence job design like below Nstd activity---->job act1----> | |----------------->jobact2----->sequencer-->End loop | |------------------>job act3----> | | | start loop------------------------------------------ I am using a comma delimited list loop values in start loop which ...

Hi Dsxians,

I have around 15 stored procedures in my sybase DB with different output columns.Can i read all these procedures using a single job by passing procedure name as a parameter?Please share yours thoughts or some alternatives to pass metadata dynamically.Thanks for you time.

Hi,

I tried uv ""SELECT DISTINCT CATEGORY FMT 60 FROM DS_JOBS;" from the project directory from command prompt. But i got "Command Not Found". Can u please suggest me

Hi folks, Can anybody tell me how to get list of category names in a project from command prompt. I mean for list of projects "dsjob -lprojects" and for list of jobs "dsjob -ljobs". In the same way is there any option to get list of categories in a project. Please suggest me Than...

Can anybody tell me the syntax and description about dsjob command. Please suggest me

Thanks in advance.

Thanks folks for your timely help.

hi,

Can anybody tell me how can I get the list of job names. I am writing a shell script. I need to display list of job names in a particular project when the script is executed.

Please suggest me.

Thanks in advance.

Hi Dsxians, I have a server shared shared container which contains server aggregator stage taking first value of 2 columns by grouping certain columns.I included this in my parellel job and it was complied fine and aborted during the first run.The problem i am facing is that,during second time compi...

Hi,

Thanx for both the replies.Additon of parameter will cause my script to change in all the env.kirthi's command will do my job.Once again thanks to u guys.

regards
tom

Hi Dsxians, After processing my source file by the datastagejob i am archiving that file by writing the following command in after job subroutine. mv #dstage_data_dir#/MSG.txt #dstage_tmp_dir#/MSG.txt.#proc_dt# proc_dt is one of the parameter which is passing current date.I am getting the source fil...

Hi, when i hit on the export tab in the manager window am getting an error msg as "run time error '372':failed to load sstab control from TABCTL32.OCX. Your version of TABCTL32.OCX is outdated.make sure that you are using the version of the control provided with the application".i think am...