DSXchange

Thanks Ray for your support. I am afraid that I couldn't make my requirement clear to you all. I got transaction happend to accounts for one month. I need to find the maximum (count) of consecutive credits and debits per account. So my input data is as follows Row Seq Account Transaction Date Debit/...

I want to find the maxmium (count) of consecutive C ro D for each account?

Hi All,

Could you please let me know, how to connect to AS400 from datastage to fetch data from AS400 physical files (tables)?

What are steps to be done for the setup?

Regards,
Jaison T J

I need to update existing rows in a table to set a column value to somevalue if there is atlest one row in source file and after update, I need to insert (append) the source file rows to that table.

Is this can be done in one datastage job.

Please advise.

Is there any way to find latest compiled date of a datastage job?

I have deleted few jobs from the folder using designer client, its deleted from the folder but when I listed the jobs using dsjob command I can see those jobs in the list. How can I delete all those unwanted jobs (those are not present in designer client or in director)? Your help is highly apprecia...

Do you find how to solve it?
I too got the same issue... Kindly let me know if it is rectified

Thank you all for the support.I have changed my design and it is working fine now.

As Chulett replied I will change the design to process this job only if there are rows to insert.

I have a target table with 5 columns (Target Table data shown after first run) Target Table SOURCE_DATE---ENDDATE----RUN_ID---FROM_DATE----TO_DATE 01-JAN-2013----31-DEC-9999---1-------01-JAN-2013---01-JAN-2013 01-JAN-2013----31-DEC-9999---1-------01-JAN-2013---07-JAN-2013 01-JAN-2013----31-DEC-9999-...

I have encrypted the password using /opt/IBM/InformationServer/ASBNode/bin/encrypt.sh shell in datastage (Linux Server).

Is there any way to decrypt the password from the encrypted password?

Regard
Jaison

I just checked my client and maximum heap size value is <add key="MaximumHeapSize" value="384" /> You have to decrease this value and Common values for MaximumHeapSize include 64, 128, 256, 348, 512, and so on. After making changes, you must restart the clients to reallocate the...

which version of DataStage client did you install? DataStage 8.5 and up needs to dotnet framework 4 full (client profile and extended) to function properly. Thanks for your reply. After removing and reinstalling Java and .Net framework 4.0 (done today), starting up issue of design center is resolved.

I had a successful installation of IBM Infosphere Client tier on windows 7 professional. When I try to open design center I am getting below error. "Failed to load the Java Virtual Machine. The most common cause of this problem is a failure of the Java Virtual Machine to allocate enough memory....

JOB Details This job reads table A using DB2 connector,with the rows read (2000 rows) it lookup another tableb B to fetch the key value from table B and then these rows along with the keys are appended to another table C using db2 connector. From the log of the job, it was found that around 900 rows...