DSXchange

Hi Vijay, Try the below commands to read all file names from the directory (i hope all files are present at same location) 1) ls -lrt | awk '{ print $9}' :- Using awk 2) ls -lrt | tr -s ' ' | cut -d ' ' -f9 :- Using cut command You can take the output of the above command to a file and you can easil...

Hi, i'm totally aggred with Ray's point. Are you able to read the fixed width data from sequentail file? I mean to say, just right click on the sequential file where you mentioned the fixed width file and see whether you are able to see the data or not. If you are having some issues while reading da...

Hi,
Do you have any specific condition to abort your job?

If yes, then please explain it.

Hi All,

Requirment:-

Send mail if records get rejected else don't send mail.

The above requirment easily achived in routine or in any scripting language (unix / Perl).

But i want to stop creation of reject file if there is no rejects to reject link

Thanks in Adv
Ashish.

Hi All, I want to find out a perticular routine say 'abc' is used by how many number of datasage job in a project. for e.g. Job Name Routine_Name Job1 abc Job2 xyz Job3 abc Job4 abc Job5 xyz Desired Output : Job1,Job3 and job4 using routine 'abc' Thanks in Adv.

Hi All, I'm trying to copy one job, but i'm unable to copy it and DS is prompting "Error: The name 'CopyofJob' is already in use. 1) I Checked the entire project and it's not visible in project :shock: 2) Also checked the Cleanup Resource if job locked, but there also i'm not able to find it :(...

Hi,

Check the dsjob command for jobstatus.

dsjob -jobstatus projectname jobname

47shailesh wrote: i is there a way to check the Status of Job i.e. STOPPED or CRASHED or ABORTED from UNIX?

Hi, As you are running your datastage on windows then, write one batch program which calls all your executable jobs and schedule it through WINDOWS Schedular. ------------------------- Hi I need to automate the job such that it can shedule the datastage on every month 2nd ..here i am not going use d...

Hi All, i want to call sqlserver stored prco in Datastage, but the problem is STP stage allows anly oracle,DB2 and sybase stored proc. :shock: and ODBC stage don't have the outlink in it. My requirement is to set some parameter to stored proc as input and take some return parameter as output. What n...

you mean to say stored procedure stage?

Or STP stage is a different stage.

i'm using DS 7.5.1.A and i have to access MSSQL stored proc.

Hi All, Using DS 7.5.1.A I want to use a stored proc. which is written in MSSQL, my questions are :- 1) which stage should i use for this? 2) I have a requirement that i have to set 3 parameters as input and it retuns two output parameters. How to implement this conditions. Please help me out from t...

I am getting below warning in change capture any one can help me

Change_Capture_263: When checking operator: Defaulting "REGION_NAME" in transfer from "beforeRec" to "outputRec".

Hi,

Just tell me your flow, which stages your using as a source datbase API or EE stage.what exactly you are doing in the job. It will be helpful to analyse.[/quote]

Thanks frined
we got the solution.

really thankful for look into my quries...

1001 question about preserve partitioning. My friend, search is the best friend for you. Your saying error, but I think it is a warning. Error and Warning is different. Preserve partitioning about the flow of your data. What is your source, is it sequential file ? *********** Thanks for info,will k...

We r using 2 lookups and 1 transformer after that in our job, but getting the error for all 3 stages mentioned above as:

"When checking operator cannot preserv partitioning of the parallel dataset for input port 0"

All partitioning property set as default.

Please reply soon.....