DSXchange

Hello, We have 42 different projects on the Development machine.out of these projects we are not able to connect one project neither from Designer,Director nor Manager. It is not giving any error or massage but it keeps trying running and then after sometime it gets hanged. 1.Do you have any idea w...

Hi, Even though I am working on EE. My DataStage EE and DB2 are on the same server containing 4 processors. But here I am working with a simple process to import metadata. I am giving the configuration here. Please let me know the problem. [bhi] Driver=/XXXXXXX/XXXXXXXXX/ascential/Ascential/DataSta...

Friends, i need to now how can i convert Oracle timestamp to DB2 date with yyyy-mm-dd format Ex. 1998-09-20 00:00:00 to 1998-09-20 Thanks in advanced. In the DSTransform you will find Timestamp.To.Date...that would do.... It didn't works... i have been making test on it but i can't do it did you ge...

reddy12 wrote:Its' just 3

swades wrote:How many possible value for type?It only just 3 or more?

Do a IF then Else on you constraint to filter your records....

jorgemunozar wrote:Friends, i need to now how can i convert Oracle timestamp to DB2 date with yyyy-mm-dd format

Ex.
1998-09-20 00:00:00 to 1998-09-20

Thanks in advanced.

In the DSTransform you will find Timestamp.To.Date...that would do....

hi, my input columns:- claim_id adj_id 1 00 1 01 1 02 2 00 2 00 3 00 3 01 3 01 4 00 4 02 5 00 5 00 5 01 o/p claim_id adj_id 3 00 3 01 3 01 5 00 5 00 5 01 my ouput shuld have only those rows where for a particular claim_id has combination of x number of 00 and y number of 01 i.e i dnt want those row...

Hi, Can u tell me where can I get DSN and as my EE is installed on AIX do I need to edit the "uvodbc.config" on the server itself? Can you explain in some more detail. Thanks in advance. Kavuri Yes ...i hope you would have defined your .odbc.ini file for the DSN ..Once you do that you got...

Hi, The Design of Job is as follows: ODBC STAGE(SQL Server)------> Transformer -------> OCI STAGE I am try to read a timestamp column from ODBC stage and write the same OCI stage which is also a timestamp column, but when i try to do this i am getting the following error: Oracle_Enterprise_0: Colum...

chulett wrote:As noted, your DBA.

I did ran the bind22 utitily it said it is successfuly binded but i don't see the DSN in the import plugin....Is ther some thing else i am missing

Hi, I am trying to create a small job. Here my source is a DB2 Enterprise stage. then a transformer and then a sequential file stage. Now when I am trying to connect to db2 by using Import--> ODBC table definitions , I am able to give username and password, it is giving my server name in the seenfr...

ray.wurlod wrote:Complex Flat File stage ...

Is the CFF stage in server also compatible with the zoned one..Pls let me know...

thanks,

Hi, I have issue like i have a data type in the copy book as PIC S9(07)V9(02) The sql data type for that is decimal(9,2)..when try to import the copybook definition for Parllel and server job..The copy book is same but with diff name though when i try to view the data on the parallel, the column it...

Hi, I have issue like i have a data type in the copy book as PIC S9(07)V9(02) The sql data type for that is decimal(9,2)..when try to import the copybook definition for Parllel and server job..The copy book is same but with diff name though when i try to view the data on the parallel, the column it ...

ray.wurlod wrote:Did you mean Ln() - logarithm - or Len() - character length - in the highlighted expression? ...

Actually i want to give Len..but by mistake i gave this Ln Logrithm....Thanks again for your help....

ray.wurlod wrote:Did you mean Ln() - logarithm - or Len() - character length - in the highlighted expression? ...

Yeah the Ln() - logarithm was giving me the warning.....