DSXchange

Mike, Truly speaking I did not give more clearity on what exactly my problem is? Yes, there are many rows in Form_Tab table. But the issue is, that in the query one of the variable accepts value from the input which is being read. For example variables :PB90H-FORM-ID and :PB90H-POL-SYMBOL-CD would h...

Hi All, I need to pull one column from a database table for which I have the following query SELECT FORM_EDITION_DT INTO :PB90H-FORM-EDITION-DT FROM FORM_TAB_V A WHERE A.FRM_ST_CD = :PB90H-FRM-ST-CD AND A.FORM_ID = :PB90H-FORM-ID AND A.FORM_EDITION_DT = (SELECT MAX(FORM_EDITION_DT) FROM FORM_TAB_V W...

Hi, I have a senario, where I have to lookup 2 columns from table A with a single lookup table LK and get their corresponding values from that table. But as far as I know lookup can be done only on one value and not more than one. For example, my input table is Column Value ---------------- lobcd BB...

Hi Everyone, I am currently working on DataStage MVS version. I designed a job and generated code for the same. I could see that to generate JCL (Compile and Run) we have got JCL Templates, but the mystery is how is the cobol code generated? From which template? Does DS really use any template? Sinc...

Hi All,

Thanks for your Inputs.

If IBM's Scheduler tool takes care of dependencies and conditional flow of jobs than I am happy.

However I am doubtful whether writing PROCS would take care of conditional flow.

Could someone throw more clarity on this.

Regards,
Rupesh

Hi All, Thanks for your replies. As per the questions you asked, refer following: 1) I installed DataStage 7.5.1.A on Windows XP Service Pack 2 2) I do have C++ Compiler but how do I check whether its .NET one? 3) Also I dont know how this C++ Compiler gets connected to DS Engine to run my jobs? 4) ...

Hi, As MVS version of DS doesnot have a sequencer, i.e; we cannot have a sequencer job created, if thats the case how do we take care of sequence of jobs running and how is the control information and flow is managed? Can I have a master JCL created which invokes another unit JCLs (unit jobs) in seq...

Hi, I am trying to run PX jobs on windows, but facing problems like it says job aborted. Could some one tell me that whether I need to have a C++ compiler?, and if yes how do i connect it to the DS engine?. Or is it like I cant have DS server installed on windows for PX? I am in desperate need. Rega...

Hi Andrew, As you mentioned, and recommendation in readme.txt file of installation cd of DS, I should have RedHat Linux Advance Server 2.1 for installation. I did install Redhat Linux Advance Server 2.1 and tried installing DS on it, but could not get further, as earlier I was stuck with the followi...

ray.wurlod wrote:A supported version of Red Hat? It does matter.

Hi Ray,

I am installing DS on Red Hat 9. Would that be a supported version. I till have problem unpacking libdslic.so.

regrds,
Rupesh

Hi,

I am facing the same problem of "Cannot unpack libdslic.so". I hav e check the directories and permissions. I have root permissions. Also I tried copying all the files in /root and installing, but no luck.

Little help will be appreciated.

Regards,
Rupesh

Hi, I am trying to Install Datastage 7.0 on Red hat Linux and I am facinf same problem "libdslic.so cannot unpack" Could someone please tell me how to resolve this error. I am in desperate need. regards, Rupesh Ok, I've just fixed the problem :), I haven't known that I should have copied d...