Column Length ( Datastage 6.0 )

iamrajy · Post by **iamrajy** » Mon Apr 26, 2004 10:54 am

we have to modify lot of tables column lengths from varchar(128) to varchar(256). Our ascential project have lot of hastables and lookup which are pointing to those tables.

Can somebody suggest the easy way to solve the problem.

chulett · Post by **chulett** » Mon Apr 26, 2004 11:04 am

I'm going to give you the same advise that Wolfgang gave you over on ADN - export the Project, edit the exported file (save the original!) and then reimport. About the only way other than changing the jobs one by one by hand...

iamrajy · Post by **iamrajy** » Mon Apr 26, 2004 11:47 am

Thanks Craig Hulett

iamrajy · Post by **iamrajy** » Mon Apr 26, 2004 2:41 pm

Craig,

I open the DSX file in text editor and couple of lines where I have to replace 128 to 256 are very confusing. Do you have any knowledge which one I have to replace.

Here are the lines from DSX file

===> I am sure that these 3 lines I have to replace
DisplaySize "128"
Precision "256"
VARCHAR(128)

===> Not sure about these line.

Value "JTYPE=0;SCOLS=<B>;<B>;D=\"<none>\";DEF=<B>;X=NETWORK_NODE.NODE_NAME;T=9;<E>;F=VarChar;G=;Z=;K=128;M=0;N=FALSE;b=NETWORK_NODE;

DataLoader_job.dsx(800089): ContainerViewSizing "0128 0146 0855 0771 0000 0001 0000 0000"
DataLoader_job.dsx(389704): StageXPos "72|648|24|240|432|600|768|960|1128|1296|1512"
DataLoader_job.dsx(413612): LeftTextPos "1284"
DataLoader_job.dsx(436610): SourceID "V0S128"
DataLoader_job.dsx(436613): Identifier "V0S128P3"
DataLoader_job.dsx(438340): StageXSize "48|48|48|1280|48|48|48"
DataLoader_job.dsx(444903): * Id128%%Result1%%3 <= XfmStagingProcess.$JobStatus
DataLoader_job.dsx(444904): * Id128%%Result2%%4 <= XfmStagingProcess.$UserStatus
DataLoader_job.dsx(444987): If (job$127$status = DSJS.RUNOK) Then GoSub L$128$START; b$127else = @False
DataLoader_job.dsx(444991): L$128$START:
DataLoader_job.dsx(444993): jb$128 = "XfmStagingProcess"
DataLoader_job.dsx(444994): h$128 = DSAttachJob(jb$128, DSJ.ERRNONE)
DataLoader_job.dsx(444995): If (Not(h$128)) Then
DataLoader_job.dsx(444996): msg$ = DSMakeMsg("DSTAGE_JSG_M_0001\\Error calling DSAttachJob(%1)<L>%2", jb$128:@FM:DSGetLastErrorMsg())
DataLoader_job.dsx(444999): h$128 = DSPrepareJob(h$128)
DataLoader_job.dsx(445000): If (Not(h$128)) Then
DataLoader_job.dsx(445001): msg$ = DSMakeMsg("DSTAGE_JSG_M_0012\\Error calling DSPrepareJob(%1)<L>%2", jb$128:@FM:DSGetLastErrorMsg())
DataLoader_job.dsx(445004): p$128$1 = (ENTITY_FILE)
DataLoader_job.dsx(445005): err$code = DSSetParam(h$128, "ENTITY_FILE", p$128$1)
DataLoader_job.dsx(445010): p$128$2 = (WORK_DIR)
DataLoader_job.dsx(445011): err$code = DSSetParam(h$128, "WORK_DIR", p$128$2)
DataLoader_job.dsx(445016): p$128$3 = (LOAD_SET_ID)
DataLoader_job.dsx(445017): err$code = DSSetParam(h$128, "LOAD_SET_ID", p$128$3)
DataLoader_job.dsx(445022): err$code = DSRunJob(h$128, DSJ.RUNNORMAL)
DataLoader_job.dsx(445024): msg$ = DSMakeMsg("DSTAGE_JSG_M_0003\\Error calling DSRunJob(%1), code=%2[E]", jb$128:@FM:err$code)
DataLoader_job.dsx(445027): handle$list<-1> = h$128
DataLoader_job.dsx(445028): id$list<-1> = "128"
DataLoader_job.dsx(445031): L$128$FINISHED:

-Thanks

chulett · Post by **chulett** » Mon Apr 26, 2004 2:56 pm

As you've noticed, you have to be very selective about what you change. Changing all occurances of "128" to "256" would be a Very Bad Idea.

Do the ones you are sure about.

Don't touch the ones you have listed as "not sure about".