DSXchange

Data is Hash partitioned within the stage

Hi,

I am using CDC stage to compare the data with Source Dataset and Target Oracle table with 2 key columns one as numeric and other as Varchar types.
Issue is for only some new records CDC output is getting duplicated to 2.
Please suggest

Thanks for your early reply..
the configurations are not done in my datastage server

how to configure db2nodes.cfg and where can i find it in the server

Hi, Our DB2 database is recently created. When we are trying to import metadata is giving error like Database connect options: dbname= 'DBRE2323K', server='s3434w33', dboptions='{user='XXXXxX',password='XXXXXXX'}'Failed to connect to the database ##E IIS-DSEE-TCDU-00063 22:17:06(006) <main_program> ...

datisaq wrote:Thanks to all for your valuable inputs....

I am able to run from the command line after explicitly specifying the user,password and server name to the "dsjob" command.

Hey i am also facing the same problem could you send me the syntax

You don't need jobid - that's just there in case you want to establish an alias for the job name. Simply use the job name. Make sure, before attempting to run a job, that it is in a runnable state - ... sorry i am not able to see what you have posted as i am not a premium member. Could anybody tell...

Hi, i am not able to run datastage job in command prompt. I am getting error like: bin/dsjob -run dev_SDES_S1_D dsmax Error running job Status code = -99 DSJE_REPERROR when i tried with passing servername and domain name i am getting error like: Error running job Status code = -99 DSJE_REPERROR $ ds...

samyamkrishna wrote:Go through this post.

http://dsxchange.com/viewtopic.php?t=13 ... c665e94b4d

Thanks,

How to get the jobid from designer

run . /opt/IBM/InformationServer/v812/Server/DSEngine/dsenv and then run the dsjob command. let me know if it works out or not. Yes it is working it is giving list of options. i tried the options they are working but ljobs is not working. infact when i am running the job like /opt/IBM/InformationSe...

The command is dsjob -ljobs projectname If this does not work try exporting the dsenv before you run teh command. can you tell me how to export dsenv i already tried with dsjob -ljobs projectname $ /opt/IBM/InformationServer/v812/Server/DSEngine/bin/dsjob -ljobs dev_EDSE_S1_D <none> Status code = 0...

samyamkrishna wrote:You want the job list or are you looking for a particular job.

I want the both infact.

i tried to search with dsjob -ljobs but it returned NONE

Could you help on this.

Hi
How to find the list of jobs in unix level
i am able to find the projects location in my server
/opt/IBM/InformationServer/Server/Projects/dev_EDSE_S1_D

in that how to get the jobs list.


Thanks in advance.

ajith_infy wrote:Apply Trim function on string before converting to date

Thanks ajith....
i got it.

swathi Singamareddygari wrote:Hi,

1)First sort the data based on Deptno and Sal in ascending order by using sort stage
2)After that use the remove duplicate stage and set Duplicates to retain to First

i made the sort stage in sequential mode....
and i got expected data

Thanks

ajith_infy wrote:Apply Trim function on string before converting to date

I did not get you...

which one to be trimmed in the string...
it is not having any unnecessary chars to trim