DSXchange

Hi, The problem occured when I tired to save an old job to a new job. During that time, my designer crashed. When I re-opened my designer, I found that I could see the new job name, but could not open the job. The message I got is 'This item has no design time information', I was not able to delete ...

Hi,

I'm currently modifying a job which generates a reject files. I may need to change the format of file. Before I do that I need to know whether there is any jobs reference that file?

Is there any easy way to find out besides to go through all jobs?

Thanks,

Carol

Hi, Is there a limitation on hash file size? I have a job which inserts new billing information in a billing table, which has more than 30 millon records. The input file provided by source system may contain the billing informaiton that already in the table. That means before I do insertion, I have ...

Improving Performance I was assigned a task to improve performance in some of Datastage jobs running on production servers. Before I start working on my task, I want to ask for some general rules regarding to performance. The rules I collected so far are listed as below 1. Using hash file for look u...

Hi, I have a very headache problem. I have a sequential file which contains more than 3 million records, every records has around 20 fields. The file contains product information about customers. Here is the samples Customer_ID, GAS, Eelectricty,Heating_Protection_Plan, Cooling_Protection_Plan, .......

I just found out from my coworker the reason I could not connect is because my password length exceeds 8. I never knew there is such restriction.

Do you mean the datastage server and my computer are located on different domain? But my co-worker could log in project using her account on my computer?

kduke wrote:Your default group should be dstage. Also it could be a network issue. Different domain servers.

Hi,

I am having difficulty connecting to Datastage server. My account belongs to group dstage, and my co-worker who has the same group as me does not have such problem.

I could not figure out the reason, any suggestion?

Carol

Thank you for all the info. I still have one more question, if I use external directory path, how I do check the content of hash file using sql statement? ( I usually exeute through datastage administrator - command button). I found this feature is very convienient during the development of job. Carol

Can I put paramter in this direct path? If not, that means the path is hard-coded in job, if I move projects from development server to production server, the same path has to be on the production server.

Carol

Hi, I'm having a question regarding to hash file. When you create hash file, you can use account name (usually I select this choice, and leave the account name empty) or use direct path. We have a datastage consultant doing consulting service in our company.He suggested us we use direct path instead...

If I select job design, that will export job design, and will allow me to edit the job in the designer after I import it.

What I meant is the program source (right below job executable) not the source code of routine.

Thanks,

Carol

Hi,

In export dialog, right below job executables, there is a check box called 'program source', what does that do? If I don't check this box, what kind of consequence will be?

Thanks,

Carol

Thanks. I solved that by compiling the job.