DSXchange

Hi AshishDevassy, I have also considered this, but I wanted to know if there were any other way to get the host name dynamically. Because the host name parameter is hard coded into every directory parameter, this would require me to change every job that uses a directory parameter. Thanks for your i...

Hi guys,

I move Sequencer jobs from a Development ,to a Test, and to a Production environment constantly and sometimes forget to change the host name parameter.

I was wondering if there is a way to get the host name and project name dynamically in a Sequencer job?

Thanks.

Hi guys,

It seems I was looking at the wrong files. Both FTP files don't have any column names as the first line.

Hi guys, I currently have two FTP jobs that use the FTP Enterprise stage. Both jobs have exact same settings, FTP from a Netezza Connector, and write a .txt file to a directory. The weird thing is that one .txt file has the column names as the first line, and the other does not. The first job uses t...

Thanks Mike.

Hi guys, I couldn't find any information on nesting a parameter inside another parameter. Is it possible to add a parameter to another parameter's value? For example: Parameter set Parameter Value #params.host# host889\ #params.top_dir# #params.host#top_directory\ Thanks.

Ah, thanks. That sounds simple enough.

I'm not sure what you mean. Do you mean to put success and failure notifications for each job activity? Right each job activity has failure trigger only.

Hi guys, Here is my current situation. I have a master sequencer(mas_seq) that will run another sequencer(Seq_stage_load). Seq_stage_load has 20 job activities(stage_job_1, stage_job_2, etc.) that will each run a parallel job. If the parallel job fails, the job activity triggers a failure notificati...

Thanks Craig. I ended up writing a routine to get the Link count.

I used this: DSGetLinkInfo(handle, Stage_Name, Link_Name, DSJ.LINKROWCOUNT)

Thanks again.

Thanks for the info. I have not worked with any server jobs, as I'm very new to DataStage. How would I set the UserStatus to the count of a table? I've been looking on this forum, and read about using a transformer, but no real detail on how the mechanics of how this is done.

Hi guys, This is the requirement: If table A's record count is 0, don't run job. I am running Job_A, which loads data into Table_A. Job_B will load data from Table_A into Table_B by truncate and insert. If Table_A is empty, Table_B will be truncated and 0 records will be inserted. I am trying to get...

Sorry I haven't replied sooner. Thanks for the input guys. This is the simple frame work that I have. %DsJob% -server %Server% -user %username% -password %password% -report %Project% %JobName1% >> %LogFileDir% :: sets the job_start_time variable to the date. :: example: "Job start time=2014-11-...

That would be great. Where can I go to get the exact syntax for that? I've been trying to check for the job status, 0 for running and 99 for not running, but have had no success at writing an IF/ELSE statement. This is the code I used to check the job status: %DsJob% -server %Server% -user %username...

Hi guys, Here is the requirements: trigger a job that is supposed to run everyday at 5AM through the DS Director; if for some reason, that job didn't run. I will be writing a batch script. I'm wondering how I can check if the job ran at 5AM. Is there a way to check for the job status of a specific j...