Search found 358 matches

by loveojha2
Thu Jul 20, 2006 12:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: not able to connect to datastage
Replies: 4
Views: 2244

Do an exact search on RPC daemon is not running (81016)

You will find lots of useful posts on this issue.
Looks like your server is not up.
by loveojha2
Wed Jul 19, 2006 11:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: getting topic tag in uppercase
Replies: 11
Views: 3598

How exactly you are parsing it.

Try something like UpCase(Ln_Mfs_Exp_msg.MsgTopic) : "123"
and see whether you are getting 123 appended or not. I guess the particular derivation is not at all executed. Are you having any condition on the derivation.
by loveojha2
Fri Jul 14, 2006 8:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Try to implement opposite of pivot
Replies: 3
Views: 871

Can be done via transformer or via some fancy sql.
Sql would be really very fancy :wink: , I won't advise to do it in sql. Do it in Transformer.
by loveojha2
Fri Jul 14, 2006 8:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Restarting an aborted job systematically
Replies: 2
Views: 1217

Use

Code: Select all

DSRunJob(JobHandle , DSJ.RUNRESET)
Which will reset the job when it is required so.
by loveojha2
Fri Jul 14, 2006 6:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transforming a delimited file into a non delimited file
Replies: 10
Views: 1752

Read the Delimited Sequential File.
Concate the columns in the transformer using : (colon) operator and write into the one Field on the target file. Pretty Straight, right?
Or you have anything else. :?
by loveojha2
Fri Jul 14, 2006 2:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CRC Info
Replies: 14
Views: 5542

Oh!
Forgot to mention the it generates a 32 bit code, hence the name.
by loveojha2
Fri Jul 14, 2006 2:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CRC Info
Replies: 14
Views: 5542

CRC stands for Cyclic Redundancy Code.
For a particular string its calculates its CRC.
Which in ETL we can use as an alternate (restricted alternate) of the string passed to it.
by loveojha2
Tue Jul 11, 2006 11:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: "Running/Restartable" job still hanging
Replies: 4
Views: 2006

Chelett is right. It should work.
Even if that doesn't work.
You can try compiling it once, it should reflect the status as compiled.
by loveojha2
Tue Jul 11, 2006 11:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pick latest file with respect to time
Replies: 3
Views: 1780

How these files are getting created ? Can you know the latest timestamp without looking at the directory? If yes then use a parameterized sequential file. If no, use something outside ds (may be perl)(me thinks) to know the file name, use Execute Command stage (sequence job) to get the timestamp and...
by loveojha2
Tue Jul 11, 2006 11:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing correct English in this forum when asking questions!
Replies: 21
Views: 6591

splayer wants correct english only in Parallel forum :wink:
by loveojha2
Tue Jul 11, 2006 4:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Query about dscmdexport
Replies: 13
Views: 6990

Try with /O=y
by loveojha2
Tue Jul 11, 2006 3:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom error
Replies: 11
Views: 2453

Ya this error clearly suggests the problem is with the Hashed Files unavilabilty. Check whether you have access (the ds user) to the folder /etlstg/DATA_FILES/HASH_FILES? If yes, check whether there you have the folder named HASH_MOB_VAS_SC1 and a file named D_HASH_MOB_VAS_SC1. If you are creating i...
by loveojha2
Tue Jul 11, 2006 3:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom error
Replies: 11
Views: 2453

Do a reset of the Job from the Director and see From Previous Log.. if it gives some additional information about the error.

What is the target column's datatype?
by loveojha2
Tue Jul 11, 2006 3:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to import excel file
Replies: 6
Views: 2534

Just open the xls document, and Do a Save As and save the file as a csv file. And its all done. :lol:
by loveojha2
Tue Jul 11, 2006 3:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Query about dscmdexport
Replies: 13
Views: 6990

The Correct syntax of the command

Code: Select all

usage: dscmdexport [/H][/U][/P][/O] project filepath
for e.g.

Code: Select all

dscmdexport /H=localhost /U=u123 /P=passwd  project filepath
Hope that helps.