DSXchange

Hi, I think I got my DSN Name, which is same as that in the ODBC driver on my client machine. Now I am getting my DSN name while importing metadata. But my problem is I am getting seen from with my default server name and it cannot be modifiable. and anothet thing is while I am connecting to the dat...

Hi,
I didn't remember what the DSN Name I setted while installing. Is there any command to see what the DSN Name I setted while installing. If I have not setted that one while installing , Is there any way to give it now.

Thanks in advance.
Kavuri

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

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 seenfro...

Hi,
here I am having millions of records in DB2. I need to transform them and pass into text files. I want to split the flat files such that each contains 50,000 records. Is there any way to do. If so how can we name the files?

Thanks in advance.

Kavuri

Hi, I am having various jobs. I would like to set parameters for database name, user, password, db2 instance name, node information. I want to write the values into a flat file and read them from that flat file. Here can I do that by running any script, like before jobsubroutine. I may miss some seq...

Hi Ray,
Is there any inbuilt function in datastage directly we can use to convert bigint into string.

Thanks
Kavuri

Hi experts, here I am getting some information in bigint format. If I convert that into string, then (i) will it fit in that ? (ii)do I lose any data? (ii) Is the data contained in the string will be in readable format or not? My second question is what is the highest number which can be inserted in...

Hi Phanee, here I am creating some jobs which are acting like adaptors. I need these to create temporary tables in the datastage project. No we have resolved this issue by creating a table in database itself and make a join there. If you have any more information please pass me. Thanks kavuri

Hi, here I am usinf Datastage for the input and output adaptor for the data type transformations and creation of new data. Here I am in the dsigning stage for the i/p and o/p adaptors using datastage. Here I need to calculate disc space required. Please help me. Input adapter: amount of temporary di...

Hi,

can anybody tell me what is the max size of a file or table which we can maintain in a datastage job so that I can lookup for. I want to build this file everytime whenever I run my job.

Thanks
Kavuri

Sorry Craig,
here I mean is I have to reconstruct original data back at the end.

Thanks
Bhargava

Hi Craig, Here I dont need exact data as it is in the source column. I can convert it and then pass the values to another package which is already built. After I get the result from the package I need to do reverse mapping to get the original values. So here I would like to create a correspondancies...

Hi, I need to convert a bigint (64bit) into int (32bit). I dont want to lose any data and I cant strip data. I need to maintain the data ina single column again. But I dont have those many records which needs not more than 32 bit int. So one thing I am assuming is making a reference table and then u...

Hi, I am getting a bigint(64 bit) from a DB2 database. Now I need to convert it into string[max=12]. My logic here to split 64 bit int into 8 X 8 bit fields and then consider each 8 bit as a char and then concatenate to form a string. Can anybody give me an idea to solve this problem. Thanks Bhargava